What are the responsibilities and job description for the BI Developer position at Opportunities?
The BI Developer is part of a team dedicated to supporting Network Health’s Enterprise Data Warehouse. This individual will perform development, analysis, testing, debugging, documentation, implementation and maintenance of interfaces to support the Enterprise Data Warehouse and related applications. They will consult with other technical resources and key departmental users on solutions and best practices. They will monitor performance and effectiveness of the data warehouse and recommend changes as appropriate.
Job Responsibilities:
- Develops, documents, tests, and maintains data interfaces between business data sources and the various stages in the Enterprise Data Warehouse in accordance with departmental and professional standards. Performs analysis, design, coding, and maintenance of data imports and extracts.
- Consults with Technical Systems Analysts, Business Quality Analysts, Developers, Engineers, DBAs, key departmental stakeholders, and leadership on technical solutions and best practices. Provides expertise to help develop business intelligence solutions.
- Monitors and audits the Enterprise Data Warehouse for effectiveness, throughput, and responsiveness. Recommends changes as appropriate. Advises leadership on how to improve application environment and system performance. Troubleshoots customer complaints related to system performance issues.
- Maintains effective communication with customers from all departments for system development, implementation and problem resolution.
- Required to take call to assist in resolution of technical problems. May be required to work later hours when system changes are being implemented or problems arise.
- Other duties and responsibilities as assigned.
Job Requirements:
- Requires Associate Degree in Computer Science, Business or related technical field or equivalent years of experience may be substituted.
- Minimum of 2 years’ experience in program interfacing and data warehousing required, preferably in a healthcare or health insurance environment.
Job Skills:
- Excellent analytical skills
- Advanced T-SQL development, SSIS development, and database troubleshooting skills
- Basic understanding of BIML, dimensional data modeling, and BI technologies
- Experience in developing and troubleshooting SSIS and BIML
- Familiarity with data masking implementations and best practices
- Ability to work in a fast-paced environment and deliver results within deadlines and escalate when appropriate
- Knowledge of virtual database architecture
- Experience working on teams leveraging agile development methodologies
- Basic understanding of Continuous Development and Continuous Integration (CI/CD) techniques
We are proud to be an Equal Opportunity Employer who values and maintains an environment that attracts, recruits, engages and retains a diverse workforce.
