Enterprise Analytics Data Engineer
Armanino LLP2 days ago
Chicago, IL, USA +14 moreMid Level
Base Salary
$90k - $125k/yr
Responsibilities
- Build and maintain curated Gold-layer datasets, reusable analytical data products, and business-ready transformations in Microsoft Fabric.
- Translate business requirements and source data into facts, dimensions, conformed attributes, and governed business logic for enterprise analytics.
- Develop, enhance, and support Power BI semantic models, including relationships, measures, calculated logic, row-level security, refresh behavior, and performance.
- Own low- to moderate-complexity engineering work from requirements through validation and release with limited day-to-day direction.
- Use SQL and, as appropriate, Python, Spark, notebooks, DAX, or Power Query to transform, validate, troubleshoot, and reconcile analytical data.
- Create and execute unit tests, source-to-output reconciliations, regression checks, and deployment validation.
- Participate in Git-based development, pull requests, peer reviews, work-item traceability, and controlled promotion across environments.
- Contribute to CI/CD, Microsoft Fabric deployment pipelines, release automation, environment configuration, and repeatable deployment evidence.
- Investigate data discrepancies, failed refreshes, model issues, and deployment defects; resolve routine problems and escalate complex issues with diagnostic evidence.
- Maintain technical documentation, data mappings, runbooks, release notes, lineage information, and operational procedures.
- Collaborate with analytics, DataOps, governance, consulting, and business stakeholders while applying established engineering, security, documentation, change-management, and monitoring standards.
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, or a related field, or equivalent practical experience.
- At least 2 years of experience in analytics engineering, data engineering, business intelligence engineering, data development, or a closely related technical role.
- Strong working knowledge of SQL, including joins, aggregations, window functions, data profiling, troubleshooting, and source-to-output reconciliation.
- Experience building or supporting analytical datasets, dimensional models, semantic models, reporting data structures, or data transformation workflows.
- Understanding of data engineering and analytics fundamentals, including grain, keys, relationships, transformation logic, data quality, and validation.
- Ability to work independently with broad objectives, research solutions, identify gaps, and drive assigned tasks to completion.
- Ability to create and execute testing and validation plans for data accuracy, reliability, and deployment readiness.
- Strong attention to detail and appreciation for source control, documentation, operational standards, and maintainable engineering practices.
- Effective written and verbal communication skills and the ability to collaborate with senior engineers while managing day-to-day priorities.
- Preferred: hands-on experience with Microsoft Fabric components, including lakehouses, warehouses, notebooks, data pipelines, semantic models, deployment pipelines, monitoring, or capacity concepts.
- Preferred: Power BI semantic model and DAX experience, including relationships, filter context, totals, time intelligence, row-level security, and performance troubleshooting.
- Preferred: familiarity with dimensional modeling, medallion architecture, Python, PySpark, Spark SQL, Fabric notebooks, Power Query, Git, Azure DevOps, GitHub, CI/CD, deployment automation, infrastructure-as-code, and release governance.
- Preferred: experience documenting data lineage, business rules, data contracts, technical designs, runbooks, or deployment procedures.
Benefits
- Medical, dental, and vision benefits.
- Generous paid time off, paid sick time, and 11 paid holidays.
- Flexible work arrangements.
- 401(k) with profit sharing.
- Wellness program.
- Generous parental leave.
- Eligible employees at certain levels may participate in a discretionary long-term financial incentive plan, subject to plan participation rules.
Tech Stack
Categories
Data Engineering
About Armanino LLP
Armanino LLP provides audit, tax, transaction and valuation services plus governance, risk and compliance and Microsoft Dynamics consulting to mid-market and enterprise clients. Founded in 1969 and headquartered in San Ramon, California, the private partnership operates in an alternative practice structure: Armanino LLP performs attest work while Armanino Advisory LLC delivers tax and consulting. It is ranked among the Top 20 U.S. CPA and consulting firms.