BI Developer Job in Chicago, IL

Unclassified - Chicago, IL

Full-time - Mid Level

Chicago, IL

About the position

The BI Developer position is a contract-to-hire role focused on enhancing the business intelligence capabilities of a start-up organization in the healthcare sector. The role involves significant ownership and autonomy in shaping technology selection and product strategy, making it a critical position for the company's growth.

Responsibilities

• Independently establish units of work from requirements and provide accurate estimates based thereon
• Work with raw data, inspecting, cleaning, and transforming it for use in analysis
• Design ETL transformation processes
• Participate in requirements sessions and brainstorms to understand client needs
• Translate requirements into metrics and design reports to visually communicate key information
• Maintain data integrity and continuity through disciplined work processes and DRP
• Translate business requirements into technical specifications

Requirements

• Minimum of three (3) years developing data warehouses in a commercial setting
• Experience with the Microsoft SQL Server stack, particularly the BI toolset
• Ability to use, configure, and administer Microsoft SQL Server, Analysis Services (SSAS), Integration Services (SSIS), and Reporting Services (SSRS)
• Proven fluency with T-SQL, MDX, and/or DAX
• Design, interpretation, and implementation of Data Warehouse schema and processes
• Ability to work with XML documents

Benefits

• Contract-to-hire opportunity
• Opportunity to shape future technology selection and product strategy