Knights of Columbus · 6 hours ago
Senior Data Movement Engineer
United States
Full-time
Remote
Senior Level, Lead/Staff
$104K/yr - $172K/yr
8+ years exp
Maximize your interview chancesInsurance
No H1B
Insider Connection @Knights of Columbus
Get 3x more responses when you reach out via email instead of LinkedIn.
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.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
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 IICS, Talend, Boomi 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
BA or BS in Computer Science, Information Systems or related field.
10+ years' experience
Preferred
Some experience with cloud database technologies preferred
Some experience with data visualization tools (e.g. Tableau) desirable
Benefits
13 paid holidays per year in addition to vacation and paid sick leave, and flexible workweek schedules.
Certifications, designation, and tuition reimbursement.
401(k) retirement savings plan with matching company contributions, and cash balance retirement plans fully funded by the company.
Short-term disability and term life insurance fully paid for by the company;
Up to 12 weeks of childbirth leave under STD policy.
One week of fully paid parental leave for all new parents, including adoptive and foster parents.
A variety of health insurance options, including premium-level family coverage and a pre-tax Health Savings Account with employer contributions.
Long-term disability insurance;
Dental insurance;
Vision insurance;
Health club membership reimbursement;
Employee Assistance Program
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,.
1,001-5,000 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
2023-09-19
2022-04-08
Company data provided by crunchbase
