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.