25 Jan
Senior Data Movement Engineer - Hybrid
Vacancy expired!
Job Description
Title: Sr Data Movement Engineer Location: Greater New Haven County Area Duration: Full Time Core Responsibilities- Complete full life cycle of ETL/ELT development to address business needs or resolve issues including design, mappings, data transformations, scheduling and testing.
- Translate data movement requirements into technical ETL design.
- Develop ETL/ELT workflows and mappings to extract, transform, and load data into target environments.
- Develop data extraction and transmissions to external vendors.
- Develop test plans and perform unit testing.
- Create supporting documentation for new ETL processes.
- Work closely with data analysts to gain understanding of business processes and corporate data.
- Determine impacts to data warehouse structures and information flows due to changes in business or technical requirements.
- Contribute to architectural decisions to support business processes.
- Provide production support for data solutions.
- Complete root cause analysis and contribute to remediation planning and implementation.
- Perform data quality analysis, report data quality issues and propose solutions for data quality management.
- Learn and expand upon internal controls and participate in customer support.
- Perform design and code reviews in support of organizational standards.
- Mentor less experienced team members.
- Prepare effort estimation including researching and estimating costs of software development, unit testing. May provide estimates for upgrades of vendor packages upgrades and integration with existing systems.
- On Call and/or after hours work required.
- Minimum of 8 years of relevant experience in data warehousing, business intelligence tools, and the analysis of data
- Minimum of 5 years of SQL query development, preferably across multiple database management platforms, and working with dimensional and star schema data warehouse implementations
- Proficiency in ETL/ELT concepts and tools (Informatica, Talend, Boomi, IICS and PowerCenter preferred)
- Working knowledge of data warehousing concepts, structures and ETL best practices
- Experience using query tools (e.g AQT, MS Query)
- Ability to problem solve using analytical thinking skills
- Must work well independently - must be inquisitive and seek answers to complex questions without being prompted
- Strong organizational and time management skills
- Strong communication skills including verbal and written to communicate effectively with clients and management
- Strong project management skills to ensure that projects get done on time and within budget
- Effectively participates in teams and moves the team toward completion of goals
- Ability to resolve conflicts
- Some experience with cloud database technologies preferred
- Some experience with data visualization tools (e.g. Tableau) desirable
- BA or BS in Computer Science, Information Systems or related field.
- 10+ years experience
Vacancy expired!