About Us:
Atlas Systems Inc. is a Software Solutions company headquartered in East Brunswick, NJ. Incorporated in 2003, Atlas provides a comprehensive range of solutions in the areas of GRC, Technology, Procurement, Healthcare Provider, and Oracle to customers across the globe. Combining our unparalleled experience of over a decade in the software industry and global reach, we have grown with extensive capabilities across industry verticals.
For more information, please visit our website https://www.atlassystems.com/
Please click on the link below to apply for this position:
https://atlas.bamboohr.com/careers/626
QA Specialist – ETL / Data Engineering / Power BI / Microsoft Fabric
Overview
Seeking a QA Specialist with strong hands-on experience in ETL/ELT testing, SQL, data validation, and data quality, with working knowledge of Microsoft Fabric, Databricks, and Power BI.
The role involves validating data across source systems → ETL pipelines → data platforms → semantic models → Power BI, with a strong focus on reconciliation, transformation validation, migration testing, and RCA.
Key Responsibilities
• Test ETL/ELT pipelines, transformations, mappings, workflows, and data migrations.
• Perform source-to-target reconciliation, completeness, accuracy, duplicate, null, aggregation, and business-rule validations.
• Validate initial, incremental, historical, and delta loads, including insert/update/delete scenarios.
• Validate data across SQL Server, Azure SQL, Snowflake, Fabric Lakehouse/Warehouse, and Databricks.
• Test pipelines and transformations using ADF, SSIS, Informatica, Talend, Alteryx, Fabric Pipelines/Notebooks, and Databricks where applicable.
• Use SQL, Python, PySpark/Spark SQL for data validation and automation.
• Perform RCA across source → ETL → data platform → semantic model → Power BI.
• Validate Power BI reports, semantic models, relationships, DAX, filters, RLS, refresh, and backend reconciliation.
• Build reusable data validation/reconciliation automation frameworks and integrate checks into CI/CD or pipeline execution.
• Document test cases, defects, evidence, QA metrics, and release validation.
Required Skills
• Strong ETL/Data Warehouse QA experience.
• Strong SQL and data reconciliation skills.
• Hands-on experience with one or more ADF, SSIS, Informatica, Talend, Alteryx, or similar ETL tools.
• Strong understanding of data quality, ETL testing, data lineage, and migration testing.
• Working knowledge of Microsoft Fabric and/or Databricks.
• Good understanding of Power BI, semantic models, and DAX validation.
• Experience with Python/PySpark/Spark SQL for data validation is preferred.
• Strong RCA, defect management, and QA documentation
skills.
Preferred
• Fabric / Databricks migration testing
• Fabric Lakehouse/Warehouse, Pipelines, Notebooks
• Databricks, Delta Lake, PySpark
• ADF / SSIS / Informatica / Talend / Alteryx
• Power BI Service, DAX, XMLA/SemPy
• Playwright / UI automation
• Metadata-driven or reusable QA frameworks
• CI/CD and automated data-quality checks
Skills Required
- Strong experience in ETL and data warehouse QA
- Strong SQL and data reconciliation skills
- Hands-on experience with ADF, SSIS, Informatica, Talend, Alteryx, or similar ETL tools
- Understanding of data quality, ETL testing, data lineage, and migration testing
- Working knowledge of Microsoft Fabric and/or Databricks
- Understanding of Power BI, semantic models, and DAX validation
- Strong root-cause analysis, defect management, and QA documentation skills
- Experience with Python, PySpark, or Spark SQL for data validation
- Fabric or Databricks migration testing
- Experience with Fabric Lakehouse/Warehouse, Pipelines, or Notebooks
- Experience with Databricks, Delta Lake, or PySpark
- Experience with ADF, SSIS, Informatica, Talend, or Alteryx
- Experience with Power BI Service, DAX, XMLA, or SemPy
- Experience with Playwright or UI automation
- Experience building metadata-driven or reusable QA frameworks
- Experience with CI/CD and automated data-quality checks
What We Do
Atlas Systems is a technology company founded in 2003 in Princeton, New Jersey, serving Fortune 1000 and mid-sized clients across healthcare, financial services, manufacturing, and other regulated industries. We build AI-powered platforms that solve operational problems most enterprises still handle manually or through legacy systems: PRIME®: A provider data management platform used across U.S. healthcare, covering payers, providers, health systems, and provider groups. PRIME keeps provider directories accurate, automates credentialing and enrollment, and helps organizations meet compliance and directory accuracy requirements. ComplyScore®: A risk and compliance management platform covering third-party risk management, continuous compliance, and internal risk domains, including a Headless TPRM offering. Used by regulated industries including healthcare, financial services, manufacturing, and life sciences across the US, EU, APAC, and India. AInfinity®: An agentic AI automation platform that applies AI to workflows across healthcare and risk and compliance. Beyond our platforms, our IT Services division works alongside client teams and systems, providing managed IT services, infrastructure support, application development, database services, cloud migration, and IT security to organizations that need dependable, hands-on technical partners. We manage 6,000+ database instances, and our platforms are built to hold up at enterprise scale: accurate enough to pass an audit or regulatory review, and simple enough that clients get more value at a lower total cost of ownership than comparable solutions. We're small enough to know our clients by name and big enough to support Fortune 1000 operations across geographies.
Why Work With Us
We're a team-first culture where people grow fast, own real problems, and see their work reach Fortune 1000 clients from day one. We promote from within and invest in ongoing development, because our platforms are only as good as the people building them.
