Job Description:
Sr. Data Engineer will support our software developers, database architects, analysts, and data scientists on data initiatives and ensure optimal data delivery architecture is consistent throughout ongoing projects. He/She must be self-directed and comfortable supporting the data needs of multiple teams, systems, and products.
Key Responsibilities:
- Analyzes data from multiple sources and negotiates differences in storage schema using the ETL process
- Researches, troubleshoots and resolve data issues impacting extract delivery
- Displays deep understanding of requirements regarding solutions, ensures data quality and match-back to core systems transaction results
- Identifies and documents process for building data models within a single complex area of business
- Assembles large and complex data sets; develops data models based on specifications using structured data sets
- Develops familiarity with emerging and complex automation and technologies that support business processes
- Conducts necessary data transformations to populate data into a warehouse table structure that is optimized for reporting
- Isolates and defines core reusable data assets that support the long-term business strategy for development efforts
- Reviews data analysis and data mapping logic; identifies recurring causes for defects and works proactively to resolve issues; reviews fixes with the data governance teams
- Manages delivery of projects in partnership with business stakeholders by demonstrating a deep understanding of the business needs and how technical analysis can produce solutions
Qualification and Expected Skill Set:
- 4+ years of experience in IT, 2+ years developing ETL/ELT processes
- Extensive data warehouse platform implementation, data architecture best practices, and support and governance experience
- Extensive data management experience (3+ years) driving and managing data platforms (Database Administration, data warehouse, data modeling, tuning, optimization, and data virtualization)
- Experience and understanding of integrating disparate datasets into a centralized platform and a combined view of common data points
- Track record of success in a fast-paced environment
- Bachelor’s degree in IT, CS, or related discipline or equivalent number of years of work experience
- Fluent in advanced SQL scripting and/or development