Data Modeller - no C2C

NO SUBCONTRACTORS or 3rd party applicants should apply. Also, we cannot sponsor visas for this role.

Experienced Data And Analytics Engineer

• Summary: Mid or Senior level experience as a Data specialist with modelling, mapping and technical data analysis skills. This person will have good data analytics and SQL experience
• Duration – Contract to perm hire. Many years for a W2 employee who wants to convert to a full time employee
• Location – Milwaukee, WI - hybrid setting, working 3 days in the office and 2 days remotely
• Temporary hourly rate: $70-75 W2 +benefits

Position Responsibilities

Business Partnership & Solution Leadership

• Serve as the primary data and analytics partner for assigned business areas, building strong relationships with business leaders and key stakeholders.
• Lead discovery sessions, requirements gathering, and solution design workshops to understand business objectives, challenges, and opportunities.
• Translate business strategies and analytical needs into scalable data and analytics solutions.
• Develop and maintain solution roadmaps aligned to business priorities and enterprise data strategy.
• Influence prioritization, scope, and solution direction through data-driven decision-making and strong stakeholder engagement.
• Communicate complex technical concepts to both technical and non-technical audiences.
• Drive alignment across business and technology teams while proactively managing expectations, risks, dependencies, and delivery outcomes.
• Act as a trusted advisor, identifying opportunities to leverage data and analytics to improve decision-making, operational efficiency, and business outcomes.

Data Architecture & Solution Design

• Design and architect scalable analytics solutions leveraging Cloud, ETL and Data Visualization tools.
• Lead conceptual, logical, and physical data modeling efforts utilizing both dimensional and relational modeling techniques.
• Apply modern data architecture principles to create sustainable, scalable, and maintainable solutions.
• Develop source-to-target mappings, transformation logic, and data lineage documentation.
• Establish and promote best practices for analytics engineering, data governance, data quality, and platform design.
• Lead architecture reviews, technical design discussions, and strategic data initiatives.

Analytics Engineering & Data Development

• Design, build, test, deploy, and support dbt models, transformation frameworks, and analytics solutions.
• Develop scalable ELT solutions utilizing Snowflake and modern data integration tools.
• Build curated analytics datasets and semantic models that enable enterprise reporting and self-service analytics.
• Optimize data pipelines and transformations for performance, scalability, reliability, and maintainability.
• Implement automated testing, monitoring, and data quality controls throughout the analytics lifecycle.
• Support CI/CD and DevOps practices within the analytics engineering environment.

Snowflake Platform Development

• Design and implement Snowflake databases, schemas, and data products.
• Optimize Snowflake performance, storage utilization, and query efficiency.
• Leverage Snowflake capabilities including streams, tasks, dynamic tables, secure views, and data sharing.
• Partner with platform and infrastructure teams to ensure security, governance, reliability, and operational excellence.
• Contribute to the evolution of Baird's cloud data platform strategy and standards.

Business Intelligence & Data Delivery

• Design and develop Power BI semantic models, dashboards, and reports that deliver actionable business insights.
• Implement best practices for data visualization, performance optimization, and user experience.
• Enable self-service analytics through scalable datasets and reporting frameworks.
• Provide training, mentoring, and support to business stakeholders and analytics consumers.
• Champion adoption of analytics solutions and drive measurable business value.

Technical Profile

Required Qualifications

• 7+ years of experience delivering enterprise data and analytics solutions in complex environments.
• Demonstrated success leading stakeholder engagement, business discovery, requirements gathering, and solution design initiatives.
• Proven ability to influence business partners and translate business needs into technical solutions.
• Strong expertise in dimensional modeling, data warehousing, analytics engineering, and data architecture practices.
• Experience designing and implementing end-to-end cloud-based data and analytics solutions.
• Advanced SQL development and performance optimization skills.
• Strong understanding of data governance, lineage, metadata management, and data quality concepts.
• Experience leading cross-functional initiatives involving both business and technology teams.
• Experience working within Agile delivery environments.