ATC · 22 hours ago
Senior Data Warehouse Engineer
Wisconsin, United States
Contract
Hybrid
Mid, Senior Level
4+ years expATC is seeking an experienced Data Warehouse Developer to support enterprise data warehouse initiatives. The role involves designing and optimizing data warehouse solutions, ensuring data quality and performance, and collaborating with technical and business teams to deliver high-quality data solutions.
SoftwareMedia and EntertainmentAppsInformation TechnologyAnimationMobile Apps
Responsibilities
Design, develop, and maintain relational databases for data storage and data mining
Perform data warehouse design and testing, including data design, database architecture, metadata, and repository creation
Develop processes and procedures for reliable data entry into data warehousing systems
Develop ETL mapping specifications to ensure reliability and quality of loaded data
Continuously improve performance and tuning of the data warehouse while ensuring data security
Work with IT teams and business users to understand requirements and implement solutions
Participate in the full SDLC: planning, analysis, design, coding, testing, implementation, and support
Develop test plans, test cases, and QA processes; identify and resolve defects
Conduct requirements gathering sessions and facilitate meetings with stakeholders
Collaborate across large teams to deliver effective data solutions
Qualification
Required
Moderate to strong experience in data warehousing process design and development
Data warehouse performance tuning using Informatica
Strong data management and data analysis skills using SQL
Knowledge of relational database technologies (SQL Server)
Experience with Informatica Intelligent Data Management Cloud (IDMC) – 2+ years
Experience with Informatica PowerCenter – 4+ years
Experience with Kimball data warehouse design principles – 2+ years
Experience with relational and dimensional data models
Experience with Slowly Changing Dimensions (SCD)
Experience with DB2 – 2+ years
Experience with Oracle database querying and reporting – 3+ years
Experience with technical writing and documentation – 3+ years
Experience with implementation of large, complex data models and processes – 2+ years
Experience with Business Objects or other BI tools – 3+ years
Experience with dashboarding and visualization using Tableau – 2+ years
Knowledge of data privacy regulations in government or regulated environments
Experience with Mainframe technologies (COBOL, DB2) is a plus
Preferred
Prior experience working with state government or highly regulated environments
Experience working with large agencies or departments handling sensitive data
Company
ATC
Founded in the wake of the 2008 Great Recession, ATC has evolved into a dynamic tech company, known for its ability to adapt quickly to the ever-changing business landscape.
201-500 employees
H1B Sponsorship
ATC 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 (24)
2024 (12)
2023 (13)
2022 (7)
2021 (23)
2020 (38)
Funding
Current Stage
Growth StageLeadership Team
Zainab (Ameera) A
Director of Partnerships & Training Departments/Senior Agile Specialist
Company data provided by crunchbase