Enterprise Analytics Data Engineer

Armanino LLP • San Jose, CA

5d • $90,000 - $125,000

About The Position

The Enterprise Analytics Data Engineer builds and maintains curated Gold-layer datasets, reusable analytical data products, and business-ready transformations within Microsoft Fabric. The role translates business requirements and source-system data into facts, dimensions, conformed attributes, and governed business logic, and develops and supports Power BI semantic models.

The position owns low- to moderate-complexity engineering work with limited day-to-day direction, taking assigned work from requirements through validation and release. It partners with senior analytics engineers and cross-functional teams, applying established architecture, engineering, security, documentation, change-management, and operational standards while gradually expanding independent ownership.

The engineer uses SQL and, where appropriate, Python, Spark, notebooks, DAX, or Power Query to transform and validate data; performs testing and reconciliation; contributes to Git-based development and deployment practices; investigates data and release issues; and maintains technical and operational documentation.

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 concepts.
• Ability to work independently with broad objectives, identify gaps, research solutions, and complete assigned tasks before escalating for assistance.
• Strong problem-solving skills and learning agility, and interest in understanding both technical solutions and the business processes they support.
• Ability to create and execute practical testing and validation plans that confirm 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, including collaboration with senior engineers and independent management of day-to-day work and priorities.

Nice To Haves

• Hands-on experience with Microsoft Fabric components such as lakehouses, warehouses, notebooks, data pipelines, semantic models, deployment pipelines, monitoring, or capacity concepts.
• Experience with Power BI semantic models and DAX, including relationships, filter context, totals, time intelligence, row-level security, and performance troubleshooting.
• Familiarity with dimensional modeling and medallion architecture, particularly developing curated Gold-layer data products from governed Bronze and Silver foundations.
• Experience with Python, PySpark, Spark SQL, Fabric notebooks, Power Query, or comparable data transformation technologies.
• Experience using Git, branching strategies, pull requests, code reviews, and work-item-linked development practices.
• Exposure to Azure DevOps, GitHub, CI/CD, deployment automation, infrastructure-as-code, environment configuration, or release governance.
• Experience documenting data lineage, business rules, data contracts, technical designs, runbooks, or deployment procedures.
• Experience working in an evolving environment where architecture, standards, and processes are being established while delivery continues.

Responsibilities

• Build and maintain curated Gold-layer datasets, reusable analytical data products, and business-ready transformations within Microsoft Fabric.
• Translate business requirements and source-system data into well-structured facts, dimensions, conformed attributes, and governed business logic that support enterprise analytics.
• Develop, enhance, and support Power BI semantic models, including relationships, measures, calculated logic, row-level security, refresh behavior, and performance considerations.
• Own low- to moderate-complexity engineering work with limited day-to-day direction, researching solutions and driving assigned work from requirements through validation and release.
• Partner with senior analytics engineers to learn architecture and development patterns, take on repeatable work, and expand independent ownership over time.
• 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 to verify grain, joins, totals, historical behavior, and downstream readiness.
• Participate in Git-based development practices, including branches, pull requests, peer reviews, work-item traceability, and controlled promotion through development, test, and production environments.
• Learn and 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; document findings, resolve routine problems, and escalate complex issues with diagnostic evidence.
• Create and maintain technical documentation, data mapping, runbooks, release notes, lineage information, and operational procedures.
• Collaborate with Enterprise Analytics & Insights, DataOps, governance, consultants, and business stakeholders while maintaining ownership of assigned day-to-day work.
• Apply established naming, security, documentation, change-management, monitoring, and engineering standards, and recommend practical improvements as experience grows.

Benefits

• Medical, dental, and vision benefits
• Generous PTO plan and paid sick time
• Flexible work arrangements
• 401(k) with profit sharing
• Wellness program
• Generous parental leave
• 11 paid holidays
• Eligible employees at certain levels can participate in a discretionary long-term financial incentive plan, subject to plan participation rules.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level