Data & Analytics Engineer

Join Robert W. Baird in a hybrid Milwaukee role focused on data and analytics excellence. This position offers a benefits-forward environment with a values-driven culture, opportunities to engage with a multicultural community, and the recognition of a Best Place to Work. You’ll design, build, and deliver scalable data pipelines and analytics-ready datasets, partnering with stakeholders to drive data-driven decision making.

Benefits and culture

The role embodies The Baird Way, access to Our Multicultural Community Conference, and the firm’s ongoing commitment to being a Best Place to Work. A hybrid work setup in Milwaukee supports collaboration with teams while maintaining flexibility for focused work.

Responsibilities

• Contribute to the design, development, and ongoing maintenance of data pipelines that ingest and transform financial services data.
• Apply data modeling techniques, including 3NF and dimensional models, to create analytics-ready datasets.
• Analyze and profile source data to understand quality characteristics and support reliable outcomes.
• Develop and validate source-to-target mappings and the associated transformation logic.
• Implement and test end-to-end data solutions under the guidance of senior engineers.
• Adhere to established practices to protect and properly handle sensitive data.
• Support data discovery efforts and prototype datasets that integrate multiple data sources.
• Leverage existing tools to enable reporting and visualization for financial services users.
• Document datasets and transformations to support usability and adoption.
• Deliver work incrementally while adapting to changing priorities.
• Collaborate with delivery team members, architects, and business partners.
• Communicate progress, risks, and dependencies clearly.
• Learn and apply Baird data standards, tools, and best practices.
• Seek feedback and coaching from senior Data & Analytics Engineers.
• Continuously build skills through training, documentation, and hands-on experience.

Requirements

• 5 to 7 years of experience delivering data and analytics solutions in a collaborative environment.
• Experience in data engineering, analytics engineering, business intelligence development, or a related data-focused role.
• Strong SQL skills and familiarity with relational database concepts and best practices.
• Experience performing data analysis, profiling, validation, and troubleshooting to support reliable data solutions.
• Ability to partner effectively with business stakeholders to understand requirements and support analytics needs.
• Strong problem-solving skills, intellectual curiosity, and a desire to continuously grow technical expertise.
• Experience with databases and platforms such as SQL Server, Snowflake, Azure SQL Database, and Azure Data Lake.
• Experience writing queries and developing solutions using SQL, T-SQL, Azure Data Studio, or similar tools.
• Familiarity with BI and analytics tools such as Power BI, Alteryx, or comparable platforms.
• Working knowledge of data modeling and governance concepts, including 3NF, dimensional modeling, data mapping, data profiling, and data quality practices.
• Experience working with common data formats such as CSV, JSON, XML, and Parquet.
• Experience in a regulated or data-sensitive environment is preferred.

Technologies

• SQL Server
• Snowflake
• Azure SQL Database
• Azure Data Lake
• SQL
• T-SQL
• Azure Data Studio
• Power BI
• Alteryx

Related jobs

• Data Integration Developer
• Senior Annuity & Insurance Supervision Officer
• Business Analyst

More about our firm

• The Baird Way
• Our Multicultural Community Conference
• Honored to be a Best Place to Work