Solution Architect - Azure Data Analytics/Data Platform

Job Summary

Core BTS is looking for an Azure Data and Analytics Consultant to join our growing team. You will work alongside your peers to design, build, and deliver end-to-end data and analytics solutions for enterprise clients. You should have data engineering experience in Azure and be familiar with modern data platform technologies like Azure Analysis Services, Azure Data Lake, Azure Databricks, Azure Data Warehouse, and Azure Data Factory.

Essential Duties

• Discuss best practices and strategies for modern data and analytics with clients
• Integrate data sources to build models and reports for business users
• Configure and operationalize cloud infrastructure in Azure
• Speak intelligently to Microsoft’s cloud data strategy and roadmap
• Stay current Microsoft technologies and modern data platform best practices

Required Skills

Consulting

• Ability to work independently and as a member of a team
• Strong written and oral communication skills
• Strong troubleshooting skills
• Ability to adjust to new client cultures and projects
• Adapt positively to change by embracing new practices, processes, or circumstances
• Present a positive, professional, and self-confident image
• Respond to clients in a timely and professional manner
• Understand and strive to consistently meet or exceed client expectations
• Collaborate with clients to identify and address their business needs
• Communicate accurately, concisely, and effectively
• Respectfully listen to others’ ideas and concerns with an open mind

Leadership

• Display a strong commitment to Core’s vision, mission, and values
• Meet commitments to others and deliver on time
• Hold self and others accountable for responsibilities
• Accept responsibility for own decisions and actions without excuses
• Self-starter

Technical

• Data engineering experience in Azure
• Familiarity with modern data platform technologies like Azure Analysis Services, Azure Data Lake, Azure Databricks, Azure Data Warehouse, and Azure Data Factory
• 3+ years of experience in data engineering and modeling
• Ability to design an end-to-end data analytics solution architecture and drive its implementation
• Deep understanding of Agile engineering practices
• Data Warehousing
• Data ETL/ELT
• Data Modeling (Dimensional/Kimball)
• T-SQL
• Azure Data Factory (or strong SSIS experience)
• Azure Data Lake Store
• SQL Server/Azure SQL
• Azure Analysis Services or SQL Server Analysis Services (SSAS) - Tabular
• Azure DevOps/Continuous Integration & Continuous Delivery

Preferred Skills

• Azure Synapse/Azure SQL Data Warehouse
• Power BI/DAX
• Databricks
• Azure Functions
• Azure Logic Apps
• Azure AD
• Data Vault
• Database administration and performance tuning
• SQL Server Integration Services (SSIS)
• Python
• Application development experience
• Previous consulting experience

Desirable Skills

• HDFS
• Azure Stream Analytics/Azure Event Hub
• Azure Data Lake Analytics/Apache Hive
• Azure Cosmos DB
• Apache Spark/HDInsight
• PowerShell
• .NET development
• R/Scala
• ASP.NET MVC/Web API
• Snowflake/BigQuery/Redshift

Other Relevant Skills

• HDFS
• Azure Stream Analytics/Azure Event Hub
• Azure Data Lake Analytics/Apache Hive
• Azure Cosmos DB
• Apache Spark/HDInsight
• PowerShell
• .NET development
• R/Scala
• ASP.NET MVC/Web API
• Snowflake/BigQuery/Redshift

Travel

• Travel is expected to be infrequent, but candidates must be willing to travel up to 10% of the time.

Benefits

You'll love working at Core BTS not just for the usual benefits, but for our environment and culture!

• You'll work with a great group of people in a highly collaborative team and results oriented atmosphere
• You'll have the opportunity to work in a dynamic and extremely positive environment where there is always the opportunity to challenge your skills and reall