Enterprise Analytics Data Engineer

Armanino; Denver (CO); Sur place; USD 90 000 - 125 000; Plein temps

Avantages offerts par ce poste

Medical benefits

PTO & holidays

Flexible work arrangements

401K with match

Wellness program

Parental leave

Résumé du poste

Armanino is seeking an Analytics Engineer to build and maintain data products in Microsoft Fabric and to develop robust Power BI models. You will translate business requirements into governed data structures, implement tests, and collaborate with senior engineers to learn patterns and governance practices.

Qualifications include a 2+ year track record in analytics engineering, strong SQL, and experience with Power BI, Python, and Git.

Qualifications

• Bachelor's degree or equivalent practical experience in a related field.
• 2+ years in analytics engineering, data engineering, BI engineering, or related technical role.
• Strong SQL skills including joins, aggregations, window functions, profiling, and reconciliation.
• Experience building or supporting analytical datasets, dimensional models, semantic models, or data transformation workflows.
• Understanding of data engineering/analytics fundamentals: grain, keys, relationships, and validation.
• Ability to work independently with broad objectives and drive tasks to completion.
• Strong problem-solving, learning agility, and business-process understanding.
• Ability to design and execute practical validation/testing plans for data accuracy and deployment readiness.
• Attention to detail with source control, documentation, and operational standards.
• Excellent written and verbal communication, collaborating with senior engineers while managing day-to-day priorities.

Responsabilités

• Build and maintain curated datasets and data products within Microsoft Fabric.
• Translate requirements into structured facts, dimensions, and governed logic for analytics.
• Develop and optimize Power BI semantic models and security, performance, and refresh behavior.
• Tackle low to moderate complexity engineering work with limited direction.
• Collaborate with senior analytics engineers to learn architecture and patterns.
• Transform and validate data using SQL, Python, Spark, notebooks, DAX, or Power Query.
• Create unit tests, reconciliations, and deployment validation for data accuracy.
• Participate in Git-based development with PRs, reviews, and traceability.
• Learn and contribute to CI/CD, Fabric deployment pipelines, and release automation.
• Investigate data discrepancies and defects; document findings with evidence.
• Create and maintain technical docs, data mappings, runbooks, and lineage information.
• Collaborate with Enterprise Analytics, DataOps, governance, and stakeholders.

Connaissances

SQL proficiency

Problem solving

Learning agility

Written & verbal communication

Independent work

Formation

Bachelor's degree in CS, IS, Data Analytics, or related field

Equivalent practical experience

Outils

Power BI

SQL

Python

Spark

Power Query

DAX

Git

Azure DevOps

Description du poste

At Armanino, you determine your career path. This means it's possible to pursue challenges you are passionate about, in industries you care about.

Armanino is proud to be Among the top 20 Largest Accounting and Consulting Firms in the Nation and one of the Best Places to Work. We have a community of resources that are ready and willing to support your ideas, build your skills and expand your professional network. We want you to integrate all aspects of your life with your career.

At Armanino, we know you don’t check-out of life when you check-in at work. That’s why we’ve created a unique work environment where your passions, work, and family & friends can overlap. We want to help you achieve growth by giving you access to a network of smart and supportive people, willing to listen to your ideas.

Job 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 closely with senior analytics engineers to learn established architecture and development patterns, absorb 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 practical unit tests, source-to-output reconciliations, regression checks, and deployment validation to confirm 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 clearly, resolve routine problems, and elevate complex issues with relevant diagnostic evidence.
• Create and maintain technical documentation, data mapping, runbooks, release notes, lineage information, and operational procedures that make solutions supportable and repeatable.
• Collaborate with Enterprise Analytics & Insights, DataOps, governance, consultants, and business stakeholders while maintaining clear 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.

Requirements

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, or a related field, or equivalent practical experience.
• Minimum of 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.
• Demonstrated ability to work independently with broad objectives, identify gaps, research solutions, and drive assigned tasks to completion before escalating for assistance.
• Strong problem-solving skills and learning agility, with a genuine interest in understanding both the technical solution and the business process it supports.
• 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 the ability to collaborate with senior engineers while independently managing day-to-day work and priorities.

Preferred Qualifications

• 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 the development of 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 active delivery continues.

“Armanino\" is the brand name under which Armanino LLP and Armanino Advisory LLC, independently owned entities, provide professional services in an alternative practice structure in accordance with law, regulations, and professional standards. Armanino LLP is a licensed independent CPA firm that provides attest services, and Armanino Advisory LLC and its subsidiary entities provide tax, advisory, and business consulting services. Armanino Advisory LLC and its subsidiary entities are not licensed CPA firms.

Armanino provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, sex, national origin, age, disability or genetics. In addition to federal law requirements, Armanino complies with applicable state and local laws governing nondiscrimination in employment in every location in which the company has facilities. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.

Armanino expressly prohibits any form of workplace harassment based on race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, or veteran status. Improper interference with the ability of Armanino employees to perform their job duties may result in discipline up to and including discharge.

Armanino does not accept unsolicited candidates, referrals, or resumes from any staffing agency, recruiting service, sourcing entity, or third-party paid service at any time. Any referrals, resumes, or candidates submitted to Armanino or any employee or owner of Armanino without a pre-existing agreement signed by both parties covering the submission will be considered the property of Armanino and not subject to any fees or charges. For existing agreements, a role must be approved and open to external search; otherwise, unsolicited and unapproved submittals and referrals will be considered Armanino property and free of fees. In addition, Talent Acquisition is the sole point of contact, and contacting others in our organization without Talent Acquisition’s knowledge will result in termination of contract.

Certain states require us to disclose the pay range and benefits summary for job openings. For Colorado, Washington, Illinois, New York, Southern California, Northern California residents, the compensation range for this position: $90,000-$125,000. Compensation may vary based on skills, role, and location. Eligible employees at certain levels can participate in a discretionary long-term financial incentive plan, subject to plan participation rules.

Benefits

• Medical, dental, vision
• Generous PTO plan and paid sick time
• Flexible work arrangements
• 401K with Profit Sharing
• Wellness program
• Generous parental leave
• 11 paid holidays

For positions based in San Francisco, consistent with the SF Fair Chance Ordinance, an arrest and conviction record will not automatically disqualify a qualified applicant from consideration.

For Individuals who would be working within the City of Los Angeles, Armanino will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws, including the City of Los Angeles’ Fair Chance Initiative for Hiring Ordinance.

To view our Consumer Notice at Collection for job applicants, please visit: https://www.armanino.com/terms/ccpa-employee-notice/

We have a community of resources that are ready and willing to support your ideas, build your skills and expand your professional network.

We have a community of resources that are ready and willing to support your ideas, build your skills and expand your professional network.