Data and Analytics Engineer

• 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, 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.

• 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, * 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