Job Title: Sr Data Movement Engineer
Location: New Haven, CT 06473 (Remote option available)
Duration: 12+ months contract - will go long term
US citizens and Green Card Holders and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1b candidates at this time
Job Description
We are embarking on the modernization of its core data
platforms. We are currently seeking a Data Movement Engineer who can assist us
with modernizing our current ETL environment, as well as begin building new
ETL/ELT workflows and data pipelines as we move towards a cloud environment.
The Data Movement Engineer will support our data architects,
data analysts, and business intelligence developers on various data
initiatives.
They must be self-directed and comfortable supporting the
data requirements of multiple teams and systems. The ideal candidate will also
possess experience in the data management domain and be willing to contribute
their technical skills and experience towards the development of elegant and
efficient data processes and systems.
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 designs.
- Develop
ETL/ELT workflows, mappings, and data pipelines 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 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.
- 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.
- Other
related duties as directed.
Skills Qualifications
Required:
- Minimum
of 5 years of relevant experience in data warehousing, business
intelligence tools, and the analysis of data
- Minimum
of 3 years of SQL query development, preferably in multiple database
management platforms, and working with normalized relational databases and
dimensional data warehouse implementations
- Proficiency
in ETL/ELT concepts and tools (Informatica IICS and PowerCenter preferred)
- Some
experience with cloud-based database technologies required
- 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
Preferred:
- Some
experience with data visualization tools (e.g. Tableau) desirable
Education
Required:
- BA or
BS in Computer Science, Information Systems or related field
- 5+
years' experience
