BI Developer

Allied Benefit Systems, Inc.; Illinois; Remote; USD 110,000 - 120,000; Full time

Job summary

A leading company in the Information Technology sector is seeking a skilled Business Intelligence (BI) Developer to design and implement BI solutions. The role involves collaborating with stakeholders to transform data into insights, developing interactive reports, and ensuring data accuracy. Ideal candidates will have extensive experience with Microsoft technologies and a strong analytical background.

Benefits

Medical, Dental, Vision Insurance

Generous Paid Time Off

Tuition Reimbursement

Technology Stipend

Qualifications

• 7+ years of experience as a BI Developer or similar role.
• Strong proficiency in Microsoft SQL Server, T-SQL, and SSIS.
• Experience with Domo's BI platform is a plus.

Responsibilities

• Design and implement BI solutions using Microsoft technologies.
• Develop and maintain reports and dashboards using Domo and Power BI.
• Collaborate with stakeholders to gather business requirements.

Skills

Data Analysis

SQL

Communication

Problem Solving

Education

Bachelor’s degree in computer science or information technology

Tools

Microsoft BI Tools

Domo

SQL Server

Power BI

SSIS

Job description

Job Details

Job Location: Allied Benefit Systems - CHICAGO, IL

Position Type: Full Time

Salary Range: $110000.00 - $120000.00 Salary

Job Category: Information Technology

Description

POSITION SUMMARY

We are seeking a skilled and detail-oriented Business Intelligence (BI) Developer to join our team. The successful candidate will be responsible for designing, developing, and implementing BI solutions using Microsoft technologies and Domo. This person will work closely with stakeholders to transform data into insights that drive business decisions.

ESSENTIAL FUNCTIONS:

• Collaborate with business stakeholders to gather and understand business requirements and translate them into technical specifications.
• Develop and maintain interactive reports, dashboards, and visualizations using Domo and Microsoft BI Tools, including Power BI, SQL Server Reporting Services (SSRS) and Domo.

• Design and implement ETL processes using SQL Server Integration Services (SSIS to consolidate data from various sources into a central data warehouse.
• Ensure data accuracy, quality, and integrity by developing and executing data validation and cleansing processes.

• Create and optimize SQL queries, stored procedures, and database structures to support BI activities and reporting requirements.
• Maintain and manage large datasets, ensuring high performance and availability.

• Work closely with IT and business teams to align BI initiatives with organizational goals.
• Provide training and support to business users on BI tools and data-driven decision making.

• Stay current with the latest BI technologies and trends.
• Evaluate and recommend new tools and technologies to enhance the BI infrastructure.

EDUCATION

• Bachelor’s degree in computer science or information technology or equivalent work experience required.

EXPERIENCE AND SKILLS

• 7+ years of proven experience as a BI Developer or similar role, with a focus on Microsoft technologies and Domo required
• Strong proficiency in Microsoft SQL Server, T-SQL, and SSIS.
• Demonstrated expertise in developing reports and dashboards using Power BI and/or other Microsoft tools.
• Strong analytical skills to interpret complex data and create actionable insights.
• Excellent communication skills, both verbal and written, for effectively interacting with technical and non-technical stakeholders.

• Experience with other data visualization tools is a plus.
• Hands-on experience with Domo's BI platform.
• Familiarity with cloud-based data solutions such as Azure.
• Understanding of data warehousing concepts and methodologies.
• Microsoft Certifications in relevant areas (e.g., Microsoft Certified: Data Analyst Associate) are a plus.

POSITION COMPETENCIES

• Job Knowledge

• Time Management
• Accountability
• Communication
• Initiative
• Customer Focus

PHYSICAL DEMANDS

• This is an office environment requiring extended sitting and computer work

WORK ENVIRONMENT

• Remote

The company has reviewed this job description to ensure that essential functions and basic duties have been included. It is not intended to be construed as an exhaustive list of all functions, responsibilities, skills and abilities. Additional functions and requirements may be assigned by supervisors as deemed appropriate.

Compensation is not limited to base salary. Allied values our Total Rewards, and offers a competitive Benefit Package including, but not limited to, Medical, Dental, Vision, Life & Disability Insurance, Generous Paid Time Off, Tuition Reimbursement, EAP, and a Technology Stipend.

Allied reserves the right to amend, change, alter, and revise, pay ranges and benefits offerings at any time. All applicants acknowledge that by applying to the position you understand that the specific pay range is contingent upon meeting the qualification and requirements of the role, and for the successful completion of the interview selection and process. It is at the Company's discretion to determine what pay is provided to a candidate within the range associated with the role.

Qualifications