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 and re-executes unit tests to validate results
• 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
• Minimum of 3 years’ experience on one platform, or any combination of education and experience that would provide an equivalent background
• Experience with multiple Business Intelligence tools, multi database, multi-language or multi business applications preferred highly preferred
• Experience leading people, small projects and providing 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