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.