Primary Accountabilities
*Develops scalable, innovative solutions for extracting, transforming, and moving data.
*Performs data profiling and data analysis to assist in understanding the data.
*Optimizes data models through normalization, table analysis and review of queries.
*Presents outcomes of analytic models in a format easily understood by the business.
*Performs ETL/ELT functions for new or existing sources.
*Conducts requirements gathering with business stakeholders and users to plan a roadmap of project activities.
*Works with the business to assess the validity of the data and achieve minimum levels of quality.
*Gathers and compiles data using various data collection techniques in response to data requests.
*Creates code or GUI data mappings while following company data standards and approaches.
*Collaborates with others responsible for pipeline development. Supervision
QUALIFICATIONS
The requirements listed below are representative of the experience, knowledge, skills and/or abilities required to perform this job. Educational Requirements Education Level Field of Study Required/Preferred Bachelor's Degree Emphasis in CIS, Software Development, analytics, operations research, computer science or other applicable field
Required Experience
*5 years of direct experience in a related field (coding, ETL Development/Engineering, analytics, or research)
*Experience with Informatica ETL/ELT tools, specifically PowerCenter, BDM/DEI, IICS products
*Experience working with Snowflake and Snowpark
* Experience in developing data pipelines utilizing Python
*Direct experience working with source APIs into a big data environment
*Proficiency in SQL required.
*Data Modeling experience utilizing Erwin Data Modeling tool
*Experience with Tidal Job Scheduling Software
*Development experience with DBT
*CI/CD Experience