Enterprise Analytics Data Engineer

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

Avantages offerts par ce poste

Medical, dental, vision

Generous PTO

401K with profit sharing

Wellness program

Parental leave

11 paid holidays

Résumé du poste

Armanino LLP is seeking a data analytics engineer to build and maintain enterprise analytics data products using Microsoft Fabric and Power BI. You will transform source-system data into governed data structures, develop scalable semantic models, and ensure data quality across complex datasets.

The role requires strong SQL, experience with BI tooling, and the ability to work with cross-functional teams to implement robust data solutions in a fast-paced environment.

Qualifications

• Bachelor's degree or equivalent practical experience.
• 2+ years in analytics engineering, data engineering, or BI engineering.
• Strong SQL skills including joins, aggregations, window functions, profiling, and reconciliation.
• Experience with analytic datasets, dimensional models, semantic models, or data transformation workflows.
• Knowledge of data engineering fundamentals, grain, keys, relationships, and data quality.
• Ability to work independently with broad objectives and drive tasks to completion.

Responsabilités

• Build and maintain curated Gold-layer datasets and data products in Microsoft Fabric.
• Translate requirements into structured facts, dimensions, and governed logic.
• Develop and support Power BI semantic models with measures, relationships, security, and performance.
• Perform data transformations using SQL, Python, Spark, or Power Query.
• Collaborate with senior engineers and stakeholders; participate in Git-based development and CI/CD processes.

Connaissances

SQL

Analytics engineering

Data modeling

Problem solving

Communication

Formation

Bachelor's degree in CS / Information Systems / Data Analytics

Outils

Python

Spark

Power BI

Git/GitHub

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.

• 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.