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.

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

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLETLPythonBusiness Intelligencedata warehousedata modelingcoding standardssystem testingtechnical specificationsdata discovery

Soft Skills

mentoringcollaborationcommunicationproblem-solvingproject managementtrainingpresentationadaptabilityprofessionalismsolution-oriented