Senior BI Developer JobBannockburn, IL
Apply Now
Back to All Jobs
Why You'll Love This Job
This senior role provides strategic leadership in the design, development, and optimization of enterprise business intelligence solutions that drive data-informed decision-making across the organization. The position leads complex integration efforts between BI platforms and enterprise systems, architect scalable databases, data warehouses, and data marts, and oversees the creation of advanced, high-performing ETL workflows. This role develops and enhances sophisticated analytics, dashboards, reports, and SSAS cubes to deliver actionable, enterprise-wide insights. Success in this role requires deep technical mastery, strong architectural and analytical thinking, the ability to translate evolving business needs into BI strategies, and the leadership to operate effectively in a dynamic, fast-paced environment.
Responsibilities
- Lead integration initiatives to merge, modernize, and optimize BI platforms with enterprise systems and critical business applications.
- Architect and oversee the design of enterprise databases, data warehouses, data marts, and data models to ensure scalability, interoperability, and long-term performance.
- Drive the end-to-end development of advanced BI solutions, including data warehouses, data marts, analytical datasets, reports, and executive dashboards.
- Design, optimize, and govern complex ETL/ELT workflows, ensuring efficient, accurate, and reliable data movement while translating high-level business needs into robust technical specifications.
- Develop, enhance, and deploy interactive analytic dashboards and reporting solutions that deliver high-impact insights for leaders and stakeholders across the organization.
- Lead the design, development, and optimization of SSAS cubes to enable multidimensional analytics and scalable business intelligence capabilities.
- Provide senior-level technical expertise in fast-paced, dynamic environments, adapting BI strategies and solutions to evolving business requirements.
- Transform complex data into strategic insights, delivering actionable recommendations that drive data-informed decision-making at all levels of the organization.
Skills & Qualifications
EDUCATION
Apply Now
- Bachelor’s degree in computer science, information systems, data science, information technology or a related field.
- A minimum of 5-7 years’ experience with relational database and data warehouse concepts.
- Proven expertise in delivering enterprise-grade BI solutions using the full Microsoft BI stack, including advanced development in SSIS, SSRS, and SSAS.
- Advanced SQL proficiency, including the ability to design and optimize complex queries, stored procedures, and performance-tuned database operations.
- Deep knowledge of database engineering and data architecture, with strong command of STAR and Snowflake schema design and extensive hands-on experience loading and maintaining large-scale data warehouses.
- Demonstrated analytical leadership, with the ability to perform complex data analysis, interpret trends, and guide business partners through data-driven insights.
- Exceptional collaboration and interpersonal skills, with a proven ability to work cross-functionally and mentor junior team members within BI and technical teams.
- Expert-level proficiency with self-service BI tools such as Power BI, Tableau, Sisense, or Qlik, including modeling, DAX/MDX, visualization design, and governance best practices.
- Strong working knowledge of Microsoft Dynamics GP and its data structures, with the ability to translate ERP data into actionable BI solutions.
- Preference for Central or Eastern time zone working hours.
- Work is performed in a remote environment with extensive computer and screen time.
- Operates in a fast-paced setting where priorities may shift to meet business needs and project deadlines.
- Regular collaboration with cross-functional teams; occasional extended hours may be required during critical releases or data initiatives.
- Expected to work independently, provide technical leadership, and maintain strict data security and confidentiality standards.