JOB SUMMARY
Responsible for data engineering functions including, but not limited to: data extract, transformation, loading, integration in support of enterprise data infrastructures, data warehouse, operational data stores and master data management. Involved in reviewing and creating innovative solutions. Subject matter expert for a single program/system. Diagnose moderate to complex issues.
MAJOR DUTIES AND RESPONSIBILITIES
Actively and consistently supports all efforts to simplify and enhance the customer experience.
Leads the implementation of data services and data movement infrastructures.
Audit implementation of data structures/models and data movement infrastructures.
Leads the implementation programming concepts such as data structures, error handling, data manipulation and I/O processing.
Provide preventative solution and troubleshoot data job failures, including but not limited to error handling, data manipulation and I/O processing.
Leads the implementation of database concepts and practices including definition and query language.
Develop, modify, enhance, and implement requirements and architecture specifications of data warehousing systems and/or processing infrastructure.
Partner with the Insights team to design, implement, and support end-to-end data solutions across multiple platforms, environments, domains, and locations.
Develop ETL processes, programs and solutions as per established standards.
Monitor and administer automated and manual data integration and ETL jobs to verify execution and measure performance.
Lead internal staff, vendors, consultants, and external partners to quickly identify and resolve data integration and ETL job issues.
Assist stakeholders in defining requirements for data capture that answer business questions and outcomes.
Coordinate with development teams to implement data capture requirements.
REQUIRED QUALIFICATIONS
Skills/Abilities and Knowledge
Ability to read, write, speak and understand English.
Experience with building use cases and providing development support to data scientists.
Experience with building use cases and providing development support to data engineers.
Experience with data lake - all data sources - building out data sets for uses cases.
Experience with building SQL/HIVE databases and tables.
Experience with querying and designing efficient warehousing structures.
Knowledge of data access methods from relational databases using SQL.
Knowledge of and hands on with web services (WSDL Soap, Restful) to access data from various source systems.
Knowledge of FTP/sFTP.
Excellent written and verbal communication skills.
Excellent analytical and troubleshooting abilities.
Education
Bachelor's degree or equivalent experience
Related Work Experience
5 years of ETL experience
5 years of Experience with SQL, Shell Script, Python, JSON
2 years of Data integration experience
2 years of Data visualization experience (Tableau, Alterx, Microstrategy)
2 years of Software engineering experience
WORKING CONDITIONS
Office environment
Here, employees don’t just have jobs, they build careers. That’s why we believe in offering a comprehensive pay and benefits package that rewards employees for their contributions to our success, supports all aspects of their well-being, and delivers real value at every stage of life.
The pay for this position has a minimum of $72200. The actual salary offer may be higher as we carefully consider a wide range of factors, including your skills, qualifications, experience and location. Also, certain positions are eligible for additional forms of compensation such as commissions or bonuses.