Senior Business Intelligence Developer

Role Overview

• Maintains active relationships with customers to determine business requirements.
• Anticipates opportunities for improvement and identifies alternate solutions.
• Collaborates with engineers for creative ideas for Web portals supporting interactive content.
• Analyzes and classifies complex change request and reviews and evaluates possible enhancements.
• Works with development team to develop and define application scope and objectives and prepare functional and/or technical specifications.
• Analyzes and evaluates detailed business and technical requirements.
• Codes and maintains complex components of information systems.
• Mentors others on coding standards and performs code reviews.
• Develops and performs system testing and fixes defects identified during testing.
• Aids in integrating activities with other IT departments for successful implementation and support of project efforts.
• Provides timely support to data information planning effort.
• Maintains technical development environment and has responsibility for implementation plan.
• Assists in developing training documentation including proactive identification of additional needs and enhancements.
• Manages small projects, mentors and provides training to others.
• Subject matter expert of one or more Business Intelligence applications.
• Establishes connectivity to operations source systems and data repositories.
• Conducts data discovery work to understand strengths, limitations, and opportunities within the currently available data.
• Develops strategic report applications from the data warehouse, using structured query language (SQL) to extract relevant sets of data.
• Establishes and maintains excellent knowledge of data warehouse database design, data definitions, and data integrity issues.
• Works with a diverse set of business partners in Operations, IT, Finance, Process Improvement, etc. to understand their needs and craft data-oriented solutions.
• Conducts training on use of dashboards/reports/applications developed.

Requirements

• Requires a BA/BS degree in Information Technology, Computer Science or related field of study
• A minimum of 3 years’ experience on one platform, or any combination of education and experience, which would provide an equivalent background.
• Experience with multiple Business Intelligence tools, multi database, multi-language or multi business application highly preferred.
• Experience leading people, small projects and provide troubleshooting support highly preferred.
• Experience presenting technical subject matters to non-technical audiences highly preferred.
• Experience in navigating new data models (both documented and undocumented) highly preferred.
• Ability to learn new subject matter and document effectively for broader team knowledge/use highly preferred.
• Professionalism, positivity, and being solution-oriented in communications and collaborations inside and outside of the team highly preferred.
• Ability to toggle effectively between several concurrent projects preferred.
• Proficiency in presenting team’s work in various forums preferred.
• Ability to train and mentor junior team members in advanced BI product development and team standard operating procedures preferred.
• Background in operations (pharmacy, drug production, contact center, manufacturing, etc.) preferred.
• Familiarity with Amazon RedShift, Snowflake, Postgres, Microsoft SQL Server, Oracle, or equivalent database software preferred.
• Familiarity with ETL coding via Python, or ETL software such as Microsoft SSIS, Informatica, or Talend preferred.

Tech Stack

• Amazon Redshift
• ETL
• Informatica
• MS SQL Server
• Oracle
• Postgres
• Python
• SQL
• SSIS

Benefits

• comprehensive benefits package
• incentive and recognition programs
• equity stock purchase
• 401k contribution
• medical benefits
• dental benefits
• vision benefits
• short and long term disability benefits