Data Architect

Bull City Talent Group; Town of Texas (WI); On-site; USD 100,000 - 130,000; Full time

Job summary

Bull City Talent Group is seeking a Senior Data Warehouse Analyst / Data Modeler to enhance an enterprise analytics platform. This role involves working with business stakeholders to gather requirements, integrate data sources, and enhance dimensional models.

The ideal candidate should have extensive experience in data warehousing, strong data modeling expertise, and excellent communication skills to bridge the gap between business and technology. A solid understanding of ERP environments is preferred.

Qualifications

• 8+ years of experience in enterprise data warehousing and analytics.
• Strong expertise in dimensional modeling and Kimball methodologies.
• Experience integrating multiple source systems into an enterprise data warehouse.

Responsibilities

• Gather and analyze business requirements from functional stakeholders.
• Design and enhance dimensional data models, including fact and dimension tables.
• Support reporting and analytics initiatives leveraging Power BI.

Skills

Data modeling expertise

Communication skills

Experience with complex ERP environments

Tools

Snowflake

Power BI

DBT

Matillion

Job description

Our client is seeking a Senior Data Warehouse Analyst / Data Modeler to enhance and expand an existing enterprise analytics platform. This role is not focused on building Snowflake infrastructure or architecture from the ground up. Instead, the successful candidate will work closely with business stakeholders to understand requirements, integrate new data sources, enhance dimensional models, and translate business needs into technical specifications for development teams.

The ideal candidate combines strong data modeling expertise with excellent communication skills and experience working with complex ERP environments.

Key Responsibilities

• Gather and analyze business requirements from functional stakeholders.
• Translate business requirements into technical specifications and source‑to‑target mapping documents for development teams.
• Design and enhance dimensional data models, including fact and dimension tables.
• Integrate new data sources into the existing enterprise data warehouse.
• Define business rules, transformations, and data quality requirements.
• Partner with developers and business users to ensure successful delivery and minimize rework.
• Participate in requirements workshops and facilitate discussions between business and technical teams.
• Perform data analysis and validate results with stakeholders.
• Support reporting and analytics initiatives leveraging Power BI.
• Ensure consistency and scalability of the enterprise data model.

Required Qualifications

• 8+ years of experience in enterprise data warehousing and analytics.
• Strong expertise in dimensional modeling and Kimball methodologies.
• Experience designing and enhancing fact tables, slowly changing dimensions (Type 1 and Type 2), hierarchies, and conformed dimensions.
• Experience translating business requirements into technical specifications.
• Experience creating source‑to‑target mapping documents and transformation rules.
• Strong communication and stakeholder management skills.
• Experience integrating multiple source systems into an enterprise data warehouse.
• Ability to work effectively with both business users and technical teams.
• Experience with Snowflake.
• Experience with ETL/ELT processes.

Preferred Qualifications

• Experience with DBT.
• Experience with Matillion.
• Experience with Power BI.
• Understanding of Order‑to‑Cash, Procure‑to‑Pay, Finance, Inventory, and Supply Chain business processes.

Ideal Candidate Profile

The successful candidate will excel at bridging the gap between business and technology. They will possess the communication skills necessary to accurately interpret business requirements and translate them into scalable data models and technical specifications, ensuring high‑quality delivery and minimizing rework. This position is best suited for a Senior Data Warehouse Analyst, Data Modeler, or Analytics Engineer with strong business acumen and ERP data experience, rather than a pure Snowflake Architect or infrastructure specialist.