Acro Service Corp · 5 hours ago
ETL Architect
Las Vegas, NV
Full-time
Onsite
Senior Level
$70/hr - $75/hr
5+ years expAcro Service Corp is seeking an ETL Architect to oversee data engineering integration and pipeline oversight. The role involves designing ETL specifications, managing data governance, and enabling reporting and advanced analytics for the organization.
ConsultingInformation TechnologyStaffing Agency
Hiring Manager
Mitra Roy
Responsibilities
Medallion Architecture Implementation: Involved in the tactical execution of the Medallion data design (Bronze/Silver/Gold) to modernize the organization’s data lakehouse environment
ETL/ELT Logic Design: Architect and manage complex Extract, Transform, Load (ETL) specifications and transformational logic to automate multi-directional data flows
Persistent Staging & Data Lifecycle: Oversee the technical requirements for staging and landing zones to ensure high-availability and historical data integrity for downstream consumption
Technical Scalability & Performance Tuning: Optimize data system performance by identifying bottlenecks in data processing and ensuring the technical framework supports high-volume, diverse data sets while adhering to security protocols
This role focuses on executing source-to-target mappings and defining the logic needed for data transformations, including type conversions and business rules. You will be responsible for setting up automated quality checks to ensure all ingested data is accurate and auditable. A key part of the position involves integrating data privacy and regulatory standards into the system design while using Master Data Management (MDM) and data cataloging tools to document technical metadata and maintain clear data lineage from start to finish
Technical Requirements Engineering: Bridge the gap between business ambiguity and technical execution by converting stakeholder needs into detailed Functional Specification Documents (FSD) and Technical Design Documents (TDD)
BI Stack Optimization: Manage and optimize the semantic layers of reporting tools (Power BI and Business Objects) to ensure performant data modeling and self-service scalability
AI Analytics Readiness: Architect the data environment for AI/ML consumption by ensuring "clean-room" data availability, feature set readiness, and robust dashboarding
SQL Querying: Execute SQL scripting to validate data sets and perform root-cause analysis on data discrepancies
Qualification
Required
A minimum of 5 years of proficiency in Data Architecture and platforms like Azure Synapse, Snowflake, or Databricks
7 years of SQL skills for data validation and root-cause analysis
A minimum of 5 years of experience with ETL/ELT logic design and managing multi-stage data flows
2 years of expertise in data governance frameworks and tools like Purview, Alation, or Collibra
7 years of technical documentation (FSD/TDD) creation and 5 years of PowerBI related data research and mapping experience
Data Modeling: Modern Data Architectures, Azure Synapse, Snowflake, Databricks Lakehouse, and Delta Lake technologies
Governance Tools: Hands-on experience with any data governance tool like Microsoft Purview, Informatica Cloud Data Governance, Alation, or Collibra
Security & Classification: Experience with Data Classification tools and implementation
Technical Methodologies: Data Governance Frameworks, Data Lineage Documentation, and Agile Scrum
Preferred
Python for data analysis
DAX/M-Code for Power BI
Company
Acro Service Corp
With singular global reach and agility, Acro Service Corporation offers you a unique integrated approach to staffing and consulting solutions.
1001-5000 employees
H1B Sponsorship
Acro Service Corp has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (13)
2024 (24)
2023 (11)
2022 (11)
2021 (12)
2020 (19)
Funding
Current Stage
Late StageLeadership Team
Chris Ehrhart, CCWP
VP - Global Supplier Partnerships
Staci Dodson Beurer SPHR, SHRM-SCP, CSP
Chief People Officer (VP, HR)
Company data provided by crunchbase