Knights of Columbus · 12 hours ago
Data Movement Engineer (Contractor)
New Haven, CT
Full-time, Contract
Hybrid
Senior Level
5+ years expThe Knights of Columbus is a tax-exempt Catholic fraternal benefit society that provides financial security to its members and their families. They are seeking a Data Movement Engineer to assist in modernizing their ETL environment and building new data workflows and pipelines while supporting various data initiatives.
Insurance
No H1B
U.S. Citizen Only
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
Qualification
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
BA or BS in Computer Science, Information Systems or related field
5+ years' experience
Preferred
Some experience with data visualization tools (e.g. Tableau) desirable
Company
Knights of Columbus
Knights of Columbus has grown from several members in one council to 15,342 councils and 1.9 million members throughout the United States,.
1001-5000 employees
Funding
Current Stage
Late StageLeadership Team
John Kennedy
Executive Vice President and Chief Financial Officer
Anthony Minopoli
Executive Vice President & Chief Investment Officer
Recent News
2025-12-18
Company data provided by crunchbase