Business Intelligence Developer

Location: Milwaukee, Wisconsin, United States

Apply

Remote Opportunity: 0

Requisition Number: 4039

Position Title: Business Intelligence Developer

External Description:

DentaQuest Business Intelligence Services team effectively and sustainably provides data solutions and tools across the organization. We integrate, transform, and improve volumes of data for the enterprise level reporting and analytic processes.

PRIMARY JOB RESPONSIBILITIES:

  • The BI Developer plays a critical role in the partnering with clients across the enterprise in analyzing, creating complex ETL solutions and analytic process for supporting internal and external reporting.
  • Develops databases SQL queries for data analysis and data extracts/loads.
  • Utilizes experience with Informatica and/or SSIS and/or equivalent ETL (Extract, Transform, Load) to load and optimize solutions from multiple data sources.
  • Analyze, debug and tune SQL databases queries for performance improvements.
  • Analyze data warehouse architecture, maintain normalized/de-normalized, star schemas and snowflakes, slowly changing dimensions, troubleshoot and recommend improvements and alternate methodologies.
  • Monitors nightly ETL processes to ensure timely completion and availability of data in data warehouse for reporting use.
  • Analyze and resolve problems and provides technical assistance as is necessary.
  • Implements corrective actions to legacy issues.
  • Conduct code reviews and participate in technical design.
  • Conduct performance analysis and optimize ETL jobs, custom SQL and T-SQL jobs.
  • Working closely with multiple teams to design, develop and maintain SQL Stored procedures and Informatica and/or SSIS ETL scripts to implement Business Intelligence Solutions.
  • Other duties as needed or required.

JOB QUALIFICATIONS:

Required:

  • B.S. or MS degree in Computer Science, business or related discipline, or equivalent experience.
  • 4 year experience T-SQL Stored Procedures, Views and T-SQL design and development using Visual Studio and SQL Management Studio (or equivalent tools).
  • 4 Years’ experience using SQL Server 2008, 2012 or equivalent tools.
  • 4 Years’ exp. with ETL tools like Informatica and/or SSIS or equivalent tools.
  • 2 years exp. in design of appropriate data structures for the development of a database system.
  • 2 year Business Intelligence Architecture and Design experience.
  • 1 year leading and managing technical projects experience.
  • Experience with data access performance tuning and performance optimization.
  • Must have a high level of initiative and sound independent judgment.
  • Must be able to collaborate and take a team-based approach.
  • Required to attend additional training as requested/deemed necessary.

Preferred:

  • 1 year’s exp. with of report development (using reporting solutions like SSRS, Tableau, Cognos) preferred.
  • Experience with Healthcare data domain is strongly preferred.

PHYSICAL DEMANDS:

  • Incumbent must be able to communicate effectively.
  • Requires overall light physical effort (up to 25lbs.)
  • Manual dexterity and sitting is required in carrying out position own position responsibilities (i.e. use of personal computer).
  • Ability to travel or move about within and outside serviced facilities required.
  • Incumbent works primarily in either a private or shared office environment.
 

City: Milwaukee

State: Wisconsin

Community / Marketing Title: Business Intelligence Developer

Company Profile:

We believe that everyone should live life free of dental disease. As a purpose-driven, double bottom line company that is improving oral health for everyone, we are transforming the oral health system – from the way we provide care and pay for it, to how we talk about it and prioritize it in our policies and communities.

Meaningful change requires a revolution in oral health. We are redefining what it means to prevent disease and provide better access to care for everyone. We are going beyond the dental chair to reshape the oral health system, addressing total health and the social and cultural factors that impact it. 

To make this revolution a reality, we harness our unique reach and insights to advance policy, financing, care, and the community. That means solving problems in a flexible and efficient way, testing and trialing to create new solutions and delivering measurable outcomes for the people we serve.

The people of DentaQuest have a common purpose, and we work together with passion, perseverance and focus to achieve a nation where no child suffers from the pain of tooth decay. Where adults keep all their teeth for their entire lives. Where every person has access to quality dental care.

Company Profile Job:

DentaQuest Business Intelligence Services team effectively and sustainably provides data solutions and tools across the organization. We integrate, transform, and improve volumes of data for the enterprise level reporting and analytic processes. PRIMARY JOB RESPONSIBILITIES: The BI Developer plays a critical role in the partnering with clients across the enterprise in analyzing, creating complex stored procedure solutions and analytic process for supporting internal and external reporting. Develops databases, SQL queries for data analysis and data extracts/loads. Analyzes, debugs, and tunes SQL database queries for performance improvement. May analyze data warehouse architecture, maintain normalized/de-normalized data, star schemas and snowflakes, slowly changing dimensions, troubleshoot and recommend improvements and alternate methodologies. May monitor nightly ETL processes to ensure timely completion and availability of data in data warehouse for reporting use. Analyzes and resolves problems, and provides technical assistance as necessary. Implements corrective actions to legacy issues. Conducts code reviews and participates in technical design. Conducts performance analysis and optimizes ETL jobs, custom SQL and T-SQL jobs. Works closely with multiple teams to design, develop and maintain SQL stored procedures and Informatica and/or SSIS ETL scripts to implement business intelligence solutions. Other duties as needed or required. JOB QUALIFICATIONS: Required: B.S. or MS degree in Computer Science, business, or related discipline, or equivalent experience. 4 years experience T-SQL Stored Procedures, Views and T-SQL design and development using Visual Studio and SQL Server Management Studio (or equivalent tools). 4 years experience using SQL Server 2008, 2016, or equivalent tools.  2 years experience in design of appropriate data structures for the development of a database system. 2 years Business Intelligence Architecture and Design experience. 1 year experience leading and managing technical projects. Experience with data access performance tuning and performance optimization. Must have a high level of initiative and sound independent judgment. Must be able to collaborate and take a team-based approach. Required to attend additional training as requested/deemed necessary. Preferred: 1 year experience with RDL and PBIX report development using SSRS and Power BI. Experience with healthcare data domain is strongly preferred. PHYSICAL DEMANDS: Incumbent must be able to communicate effectively. Requires overall light physical effort (up to 25lbs). Manual dexterity and sitting is required in carrying out position responsibilities (i.e. use of personal computer). Ability to travel or move about within and outside serviced facilities required. Incumbent works primarily in either a private or shared office environment.

Location_formattedLocationLong: Milwaukee, Wisconsin US

CountryEEOText_Description: In accordance with our Compliance Plan, employees must conduct business in accordance with applicable laws, regulations, professional standards and ethical standards and report potential compliance or ethical issues to manager or Compliance Officer. Our Affirmative Action Program affirms our commitment to make reasonable accommodation to the known physical or mental limitation of otherwise-qualified individuals with disabilities or special disabled veterans, unless the accommodation would impose an undue hardship on the operation of our business. Please see Human Resources for additional information regarding this Program. Equal Employment Opportunity Statement: We are committed to a policy of nondiscrimination and equal opportunity for all employees and qualified applicants without regard to race, color, religion, sex (including pregnancy, gender identity, and sexual orientation), national origin, age, disability, or sexual orientation.

Need Assistance?

Can't find a job that fits what you are looking for? Submit your resume and allow one of our Talent Advisors help you in your next career move.

Update Your Resume

If you already have a resume on file with us click here to update your profile.