Data Warehouse & Business Intelligence Developer

Baird & Warner - Chicago, IL

Full-time - Mid Level

Chicago, IL

Real Estate

About the position

The Data Warehouse & Business Intelligence Developer will be responsible for designing, developing, and maintaining Data Warehouse (DW) and Business Intelligence (BI) solutions to support data analysis, reporting, and business decision-making. This role requires a strong understanding of ETL processes, data modeling, and BI tools, and the ability to work in a fast-paced environment. The position is hybrid, requiring three days of on-site work in Chicago.

Responsibilities

• Design and implement data warehouse architectures and solutions that support operational reporting and data analysis.
• Create and manage ETL (Extract, Transform, Load) processes to integrate data from multiple source systems into the data warehouse.
• Develop and deploy BI solutions using tools such as Cognos Analytics, SSRS, or other reporting platforms.
• Design and maintain data models, schemas, and database objects to ensure optimal performance and efficient querying.
• Monitor data quality and troubleshoot data issues, ensuring accurate and consistent data across the warehouse and BI systems.
• Build and optimize complex reports, dashboards, and data visualizations for business users to support decision-making.
• Work closely with business stakeholders, business analysts, and other technical teams to understand data requirements and provide technical solutions.
• Continuously assess and improve the performance of ETL processes, data warehouse queries, and BI reports.
• Create and maintain clear, comprehensive documentation for all BI and data warehousing processes, including data flow diagrams, code documentation, and system configurations.
• Provide training and support to end-users for BI Tools and solutions; including developing user guides and best practices.
• Provide support to end-users and address issues related to data, reporting, and BI tools.

Requirements

• 3+ years of experience in Data Warehouse, Business Intelligence, or ETL development.
• Strong experience with ETL tools (e.g., SQL Server Integration Services (SSIS), Talend, Informatica).
• Experience with data modeling techniques and database design.
• Proficiency in SQL for querying, optimizing, and managing relational databases (SQL Server, Oracle, etc.).
• Familiarity with BI tools such as Cognos Analytics, SSRS, etc.
• Understanding of data warehousing concepts (Star Schema, Snowflake Schema, OLAP).
• Knowledge of data governance and data quality management best practices.
• Strong analytical and problem-solving skills, with a focus on delivering solutions that meet business needs.
• Excellent verbal and written communication skills.
• Ability to effectively present technical concepts to non-technical business stakeholders.
• Ability to work independently and in collaboration with cross-functional teams.
• Ability to manage multiple tasks and prioritize effectively to meet deadlines.

Nice-to-haves

• Experience with Microsoft SQL Server Database, SSIS, SSRS, IBM Framework Manager, Cognos Data Modules/Data Sets, and/or Cognos Analytics.
• Experience with cloud technologies (AWS, Azure, GCP).
• Knowledge of data integration techniques and technologies (APIs, web services).
• Familiarity with agile development methodologies/tools (Scrum, Kanban, Jira).
• Experience with Real Estate, Mortgage, and/or Title industry knowledge.

Benefits

• Medical
• Dental
• PTO
• VTO