Data Engineer

SmithGroup is an integrated design firm with a reputation for cultivating a top-ranked culture while pioneering award-winning innovative design solutions. We blend research, data and technology with ingenuity and a creative spirit to deliver resilient, inclusive spaces that solve our clients' greatest challenges. Our teams create exceptional design solutions for healthcare, science and technology, workplace, mixed use, higher education, cultural, waterfront, parks and open spaces, and urban environments. We are looking for passionate problem solvers who want to elevate design, push boundaries and create a more resilient future.

The Corporateoffice of SmithGroupis looking for aData Engineerto join our team.

Working with us, you will:

• Design, build, and maintain ETL/ELT pipelines and data ingestion workflows using Microsoft Fabric components (pipelines, notebooks, Spark pools, machine learning models, etc.).

• Implement scalable *data transformation* solutions using PySpark and Python within the Fabric environment.

• Architect and evolve data warehouse models (star/snowflake schemas, dimensional modeling, slowly changing dimensions, facts/aggregates) to support analytics and BI.

• Collaborate with data analysts, data scientists, BI developers, and stakeholders to translate business requirements into robust data solutions.

• Build and enforce data quality checks, validation pipelines, monitoring, and alerting for ETL/ELT processes.

• Deploy and maintain CI/CD pipelines for data artifacts, notebooks, and infrastructure-as-code (IaC) where applicable.

• Optimize query performance (Spark SQL, MPP considerations), partitioning, indexing, and resource usage.

• Implement data security, access controls, and compliance practices in line with organizational policies.
• Troubleshoot operational issues, perform root cause analysis, and implement long-term fixes and performance improvements.
• Document architecture, pipelines, data models, and operational runbooks.

An ideal candidate has:

• 6 or more years of professional experience in Data Engineering, with proven experience implementing ETL/ELT workflows.

• Minimum platform experience: at least 1 year of Microsoft Fabric OR at least 3 years of Databricks running in production.

• Bachelor's degree in an IT related field or equivalent work experience

• Strong hands-on experience with the Microsoft data ecosystem (preferably Microsoft Fabric)

• Proficient in Python and PySpark for data transformation, scripting, and orchestration.

• Deep understanding of data warehouse design and dimensional modeling best practices.

• Familiarity with CI/CD for data pipelines, version control (Git), and automation tooling.

• Solid understanding of data governance, security, access control (RBAC), and compliance in cloud data platforms.

• Experience with data quality frameworks and building monitoring/alerting systems.

• Demonstrated ability to independently and effectively complete work assignments and projects in a timely fashion

• Excellent verbal and written communication skills

• Have ability to reason and apply common-sense understanding to situations encountered

At SmithGroup, we are committed to helping our staff thrive with great projects and time to unwind. We offer flexible scheduling, a hybrid work environment, 3 weeks of PTO within your first year of employment with the option of purchasing additional time off, 8 paid federal holidays, plus 15 extra Fridays off! Our benefits plan includes medical, dental, and vision coverage, wellbeing resources, paid parental leave, a flex spending account and voluntary insurance options. We invest in your future through our 401(k) program with employer matching, tuition reimbursement program, one-on-one career coaching and professional development opportunities. While we may ultimately pay more or less than a posted salary range, at the time of posting the anticipated salary range for this position is $123,000 to $145,000 annually and you are eligible for a performance-based bonus each year. To be considered for this role, please create a profile and apply!

Equal Opportunity Employer

We are an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws.If you require reasonable accommodation to complete this application, interview, or otherwise participate in the employee selection process, please direct your inquiries to careers@smithgroup.com.