Bachelor's degree in Computer Science, Information Systems, Data Analytics, Business Analytics, Engineering, or related field, or equivalent experience.
Minimum of 2 years in analytics engineering, data engineering, or business intelligence engineering.
Strong SQL skills, including joins, aggregations, and troubleshooting.
Experience with analytical datasets and data transformation workflows.
Understanding of data engineering fundamentals like grain, keys, and data quality.
Ability to work independently and drive tasks to completion.
Strong problem-solving skills and attention to detail.
Responsibilities
Build and maintain Gold-layer datasets and analytical data products in Microsoft Fabric.
Translate business requirements into structured data for enterprise analytics.
Develop and support Power BI semantic models and performance considerations.
Own low to moderate-complexity engineering tasks with minimal direction.
Collaborate with senior analytics engineers to learn and expand ownership.
Use SQL and Python/Spark for data transformation and validation.
Create and execute testing plans to ensure data accuracy and readiness.
Benefits
Opportunity to work with cutting-edge technologies like Microsoft Fabric.
Collaborative environment with senior engineers for skill development.
Exposure to CI/CD and deployment automation practices.
Engagement in a dynamic setting with evolving architecture and standards.
Access to professional growth and learning opportunities.
Full Job Description
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 escalate 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.
About Armanino
Armanino is one of the largest independent accounting and business consulting firms in the United States, with offices in California, Texas, and Illinois. The firm provides a wide range of services to clients in various industries, including audit and assurance, tax planning and compliance, business consulting, and technology consulting. Armanino is committed to delivering innovative solutions and exceptional service to help clients achieve their goals and succeed in today's rapidly changing business environment.