Business Intelligence Developer - DeWolff, Boberg & Associates

• Develop, design, and maintain ETL pipelines using data integration tools for interfacing between source application and the Database.
• Develop SQL Server stored procedures, functions, views, and triggers to be used during the ETL process.

• Document ETL data mappings, data dictionaries, processes, programs, and solutions as per established standards for data governance.
• Deliver epics, user stories, mockups, and workflows for new and improving functionality by working closely with the Operations Management Consulting Services Division
• Identify, diagnose, and solve incoming queries and issues related to client’s software setup.
• Work with the Business team(s) to assess and troubleshoot potential data or product related issues.
• Participate in business analysis activities to gather required reporting and dashboard requirements.
• Assist in developing & maintaining reports developed by Managed Service consultants for internal and external stakeholder using Worksite that provides accessible information for decision making.
• Provide support as required to ensure the availability and performance of developed reports and dashboards for both external and internal users.
• Participate in Q&A testing cycle and perform quality assurance checks prior to software release.
• Participate in the release deployment cycle.
• Provide technical assistance and cross training to other team members
• Monitor and respond quickly and effectively to requests received by clients.
• Provide exceptional customer service

• Bachelor's or Masters degree in Computer Science, Computer Engineering, Software Engineering, or a related field or foreign equivalent.

• Masters degree:
  • Two (2) years experience in writing and maintaining SQL queries
  • Two (2) years experience working with ETL tools
  • Two (2) years experience working with Java and Microsoft SQL Server databases
• Bachelors degree:
  • Five (5) years experience in writing and maintaining SQO queries
  • Five (5) years experience working with ETL tools
  • Five (5) years experience working with Java and Microsoft SQL Server databases

• Medical, Vision, Dental, Short & Long Term Disability Insurance, FSA, 401(k)
• Two weeks paid vacation + One week paid PTO + Paid year-end holiday closure

The Equal Employment Opportunity Policy of DeWolff, Boberg & Associates LLC. is to provide a fair and equal employment opportunity for all job applicants regardless of race, color, religion, national origin, gender, sexual orientation, age, marital status or disability. DB&A hires and promotes individuals solely on the basis of their qualifications for the job to be filled.  DB&A believes that all employees should be provided with a working environment which enables each team member to be productive and to work to the best of his or her ability. We do not condone or tolerate an atmosphere of intimidation or harassment based on race, color, religion, national origin, gender, sexual orientation, age, marital status or disability.

We expect and require the cooperation of all employees in maintaining a discrimination and harassment-free atmosphere.