Knights of Columbus

Data Movement Engineer – Contractor

Knights of Columbus

contract

Posted on:

Location Type: Office

Location: New Haven • Connecticut • United States

Visit company website

Explore more

✨ AI Apply
Apply

Tech Stack

CloudETLInformaticaSQL

About the role

  • 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.

Requirements

  • 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.
  • Authorization to work in the United States is required. This position is not eligible for visa sponsorship.
Benefits
  • Charity is at the core of our missions: our profits are donated to help those in need and to support our faith
  • $1.73B over the past ten years
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
ETLELTSQLdata warehousingdata quality analysisdata transformationsdata pipelinesdata extractionroot cause analysiseffort estimation
Soft Skills
analytical thinkingproblem solvingorganizational skillstime managementcommunication skillsproject managementteam participationindependenceinquisitiveness