Job description

Position Summary We are seeking an accomplished Senior Data Engineer with 8+ years of hands-on experience to join our data team. This role combines deep expertise in data pipeline engineering ETL- SQL Server, Informatica, Active Batch, and SSAS - with strong semantic modeling capabilities, including Power BI and dimensional data modeling. The ideal candidate is equally comfortable supporting and enhancing production pipelines and supporting high-performance analytical models that drive business intelligence across the enterprise. Key Responsibilities Pipeline Engineering & Production Support • Monitor, support, and enhance existing data pipelines built on SQL Server, Informatica, and Active Batch, ensuring high availability and data integrity. • Develop, maintain, and optimize ETL/ELT processes; troubleshoot performance bottlenecks and data quality issues with minimal downtime. • Manage and tune Active Batch job workflows for reliable, efficient automation. • Collaborate with cross-functional teams to resolve data incidents, communicate root cause, and implement preventive measures. • Document pipeline processes, data flows, and technical specifications to support operational continuity and knowledge transfer. Data Modeling & Semantic Layer • Design, develop, and optimize SSAS tabular models and lead migration efforts to Power BI semantic models. • Build and maintain Power BI semantic models leveraging data from SQL Server; ensure high-performance query execution. • Write, optimize, and troubleshoot SQL, DAX, and Power Query (M) to support analytics and reporting needs. • Partner with data engineers to design tables and schemas for optimal analytical performance. • Document data models, business rules, and data mappings using catalog tooling. • Ensure smooth daily operations of deployed data models; address outages promptly. Stakeholder Engagement & Mentorship • Collaborate with business and technical stakeholders to gather requirements and deliver data products aligned to business needs. • Train and mentor junior engineers and modelers on best practices for pipeline development, data modeling, and optimization. • Research and recommend tools, methods, and technologies to continuously improve data engineering and modeling practices. • Bachelor Degree in Computer Science, Management Information Systems, Engineering or related field required • 8 years of combined experience in data engineering and data modeling roles. • Expert-level proficiency in T-SQL and SQL Server (including stored procedures, views, performance tuning) preferred. • Hands-on experience with Informatica (PowerCenter or IICS) for ETL pipeline development and support preferred. • Proven experience managing and troubleshooting ActiveBatch job scheduling and workflow automation preferred. • Strong background in SSAS tabular model development and performance optimization preferred. • Advanced knowledge of DAX and Power Query (M) for Power BI semantic modeling preferred. • Solid understanding of data warehousing concepts, dimensional modeling, and ETL/ELT patterns preferred. • Strong problem-solving skills with a disciplined approach to root cause analysis and incident resolution preferred. Strongly Preferred Qualifications: • Experience with Azure Data Factory or comparable cloud orchestration platforms. • Familiarity with Big Query as a data platform for modeling and pipeline development. • Experience with Azure cloud environments and underlying infrastructure concepts. • Knowledge of scripting languages such as Python or PowerShell for pipeline automation. • Familiarity with Oracle SQL, PL/SQL. • Experience with data catalog tools such as Alation or similar platforms. • Knowledge of business processes and terminology (e.g., Finance, HR, Project Costing). • QA/QC mindset with experience validating data accuracy across analytical layers. Burns & McDonnell is making the world a better place every day. When we take on some of the world’s toughest challenges, we’re putting the industry’s best thinking to work, striving to create amazing success for our clients and amazing careers for our employee-owners. Our staff of more than 7,000 engineers, architects, construction professionals, scientists, consultants and business professionals is constantly growing. We have offices and projects across the U.S. and around the globe. We are proud to rank among FORTUNE magazine’s 100 Best Companies to Work For. Our culture, powered by 100% employee ownership, plays a major role in getting us there. Each employee brings a high level of commitment to every project. Clients have shown their appreciation of this dedication, rewarding us with a 90% repeat business rate and decades-long partnerships. That’s pretty cool for a firm that started as a small engineering consulting shop back in 1898. At Burns & McDonnell, you’ll have the opportunity to make a difference while fulfilling your personal and professional ambitions. Our entrepreneurial culture lets you guide your destiny and shape the path your career travels. And with hundreds of service specialties, your career and development options are endless. Are you ready to create amazing? Burns & McDonnell is an Equal Opportunity Employer Minorities/Females/Disabled/Veterans

Requirements

Must-haves

Pipeline Engineering & Production Support
Monitor, support, and enhance existing data pipelines built on SQL Server, Informatica, and Active Batch, ensuring high availability and data integrity.
Develop, maintain, and optimize ETL/ELT processes; troubleshoot performance bottlenecks and data quality issues with minimal downtime.
Manage and tune Active Batch job workflows for reliable, efficient automation.
Collaborate with cross-functional teams to resolve data incidents, communicate root cause, and implement preventive measures.
Document pipeline processes, data flows, and technical specifications to support operational continuity and knowledge transfer.
Data Modeling & Semantic Layer
Design, develop, and optimize SSAS tabular models and lead migration efforts to Power BI semantic models.
Build and maintain Power BI semantic models leveraging data from SQL Server; ensure high-performance query execution.
Write, optimize, and troubleshoot SQL, DAX, and Power Query (M) to support analytics and reporting needs.
Partner with data engineers to design tables and schemas for optimal analytical performance.
Document data models, business rules, and data mappings using catalog tooling.
Ensure smooth daily operations of deployed data models; address outages promptly.
Stakeholder Engagement & Mentorship
Collaborate with business and technical stakeholders to gather requirements and deliver data products aligned to business needs.
Train and mentor junior engineers and modelers on best practices for pipeline development, data modeling, and optimization.
Research and recommend tools, methods, and technologies to continuously improve data engineering and modeling practices.

Nice-to-haves

Expert-level proficiency in T-SQL and SQL Server (including stored procedures, views, performance tuning) preferred.
Hands-on experience with Informatica (PowerCenter or IICS) for ETL pipeline development and support preferred.
Proven experience managing and troubleshooting ActiveBatch job scheduling and workflow automation preferred.
Strong background in SSAS tabular model development and performance optimization preferred.
Advanced knowledge of DAX and Power Query (M) for Power BI semantic modeling preferred.
Solid understanding of data warehousing concepts, dimensional modeling, and ETL/ELT patterns preferred.
Strong problem-solving skills with a disciplined approach to root cause analysis and incident resolution preferred.

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

sqlazurepython

Platform: taleo
Effort: medium