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
- Provide mentoring and thought leadership to Data Analytics/Data Platform practice
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
Required Skills - 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
Required Skills - Technical
- 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.
- 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 and Desirable Skill - Technical
- 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
- 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
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 really move the needle
- You’ll work with large, sophisticated, and progressive clients throughout North America
- We provide a comprehensive benefits program including: Health, Vision, and Dental Insurance, Life Insurance, Health/Dependent Care Flexible Spending, 401(k) Plan, Short-Term and Long-Term Disability Coverage, Generous Vacation and Flex Time Off Programs, Company Paid Holidays, and Training and Development Opportunities.