Baird & Warner · 17 hours ago
Data Warehouse & Business Intelligence Developer
Chicago, IL
Full-time
Hybrid
Mid Level
$75K/yr - $85K/yr
3+ years expBaird & Warner is a well-respected real estate company recognized for its supportive workplace culture. They are seeking a skilled DWBI Developer to design, develop, and maintain Data Warehouse and Business Intelligence solutions that support data analysis and business decision-making.
Real Estate
Responsibilities
Data Warehouse Development: Design and implement data warehouse architectures and solutions that support operational reporting and data analysis
ETL Development: Create and manage ETL (Extract, Transform, Load) processes to integrate data from multiple source systems into the data warehouse
Business Intelligence Solutions: Develop and deploy BI solutions using tools such as Cognos Analytics, SSRS, or other reporting platforms. Ensure the availability of meaningful and actionable insights to business stakeholders
Data Modeling: Design and maintain data models, schemas, and database objects to ensure optimal performance and efficient querying
Data Quality Assurance: Monitor data quality and troubleshoot data issues, ensuring accurate and consistent data across the warehouse and BI systems
Report Development: Build and optimize complex reports, dashboards, and data visualizations for business users to support decision-making
Collaboration: Work closely with business stakeholders, business analysts, and other technical teams to understand data requirements and provide technical solutions
Performance Tuning: Continuously assess and improve the performance of ETL processes, data warehouse queries, and BI reports
Documentation: Create and maintain clear, comprehensive documentation for all BI and data warehousing processes, including data flow diagrams, code documentation, and system configurations
Training: Provide training and support to end-users for BI Tools and solutions; including developing user guides and best practices
Troubleshooting and Support: Provide support to end-users and address issues related to data, reporting, and BI tools
Qualification
Required
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
A Bachelor's degree in Computer Science, Information Technology, or a related field is preferred
Preferred
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
Vision
PTO
VTO
Company
Baird & Warner
Established in 1855, family-owned Baird & Warner is Chicagoland’s largest independent real estate services company.
1001-5000 employees
H1B Sponsorship
Baird & Warner has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Jennifer Alter Warden
Senior Advisor to the CEO
Steve Baird
Owner and CEO
Company data provided by crunchbase