Job Title: Data and Analytics Engineer Location: Milwaukee, WI Duration: 6 month contract to hire
What they need:
Key Responsibilities
Build and maintain ELT pipelines
Develop data models and architecture
Work heavily in cloud environments
Collaborate with stakeholders across business units
Translate business requirements into scalable data solutions
Support enterprise-level data integration and reporting
Required Qualifications (Non-Negotiables)
5 7+ years of experience
Strong SQL skills (critical)
Experience with:
o Cloud data platforms (Snowflake preferred)
o dbt or similar tools
o Cloud ETL tools
o Python for pipeline/environment development
Proven ability to:
o Work in larger enterprise environments
o Collaborate across teams
o Engage stakeholders effectively
Personality fit: Must be humble, collaborative, and easy to work with
Nice-to-Have:
Need stronger hands-on ability with:
o Building pipelines
o Data modeling
o Gold-layer development
Job Description:
As we continue to grow and modernize our analytics data platform, we are seeking a Senior Data & Analytics Engineer to join our IT Data & Analytics Team.
This individual will serve as a senior member of the team, partnering directly with business stakeholders to understand strategic objectives, define analytics roadmaps, gather requirements, architect solutions, and deliver scalable data and analytics capabilities using Snowflake, dbt, and Power BI.
Success in this role requires a unique blend of business acumen, stakeholder leadership, data architecture expertise, and hands-on engineering capability. The ideal candidate can lead discovery and requirements sessions, influence decision-making, translate business needs into technical solutions, and drive delivery from concept through implementation and support.
This role is expected to operate as a trusted advisor to business leaders, helping shape the direction of data and analytics initiatives while remaining actively involved in architecture, modeling, development, deployment, and ongoing support.
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 Snowflake, dbt, and Power BI.
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.
Preferred Technical Experience
Cloud Data Platform
Snowflake
dbt
Business Intelligence
Power BI
Semantic Modeling
DAX
Data Architecture & Modeling
Dimensional Modeling
Relational Modeling (3NF)
Data Warehousing Concepts (Kimball, Data Vault)
Data Engineering & DevOps
Git-based source control
CI/CD pipelines
Automated testing frameworks
Data observability and monitoring solutions
