ETL Developer

IvoryCloud is seeking an ETL Developer. In this role, you will be responsible for designing, building, and maintaining the complex data pipelines that move information from client source systems into the reporting environments that program staff and leadership rely on to make better decisions. Data extracts will come from many sources, transform through documented business rules, and load it into an Enterprise Data system., · Design, build, and maintain complex data pipelines that extract, transform, and load data into client enterprise data warehouses and data marts.

· Develop and optimize scalable ETL/ELT workflows to migrate data from multiple sources to target systems, including MRT loads.

· Tune SQL and ETL package execution to meet reliability, security, and performance requirements for large data volumes.

· Ensure data accuracy, quality, and reliability through validation, source-to-target reconciliation, and defect-free code prior to production release.

· Provide technical leadership and guidance to junior team members and enforce development and secure-coding best practices.

· Collaborate with data architects, business analysts, and quality assurance teams to deliver to schedule and meet stakeholder needs.

· Support production deployments, troubleshoot production incidents, and respond to alerts within the contract's response-time standards.

About IvoryCloud

Ivory Cloud is a purpose-driven enterprise. We go to work every day driven to achieve for our customers, learn and master new skills, and take ownership in growing those around us. Through this purpose, we do outstanding, innovative, and high-quality work.

We are building our team with a relentless focus on bettering our customers, building personal capability, and investing in the success of others. You are purpose-driven if the following describes you:

· Driven by team and personal excellence.

· Total focus on becoming a Subject Matter Expert in whatever role you have.

· Flexible thinker who solves problems with both linear and non-linear approaches.

· Excited to be a part of a growing company and committed to helping it grow.

Do you have experience in System security?, Do you have a Bachelor's degree?, · U.S. Citizenshipor Green Card holder

· Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related technical field., · 7+ years of hands-on experience designing and developing scalable ETL/ELT workflows that migrate data from multiple sources to target systems, including Master Reference Table (MRT) data.

· Demonstrated expertise optimizing SQL performance and ETL package execution for efficiency, accuracy, and reliability.

· Production experience with data integration tooling such as IBM DataStage, SQL Server Integration Services (SSIS), and Databricks, plus orchestration with Control-M.

· Working knowledge of AWS data services (S3, Athena, Glue Crawler and Catalog, Redshift, EventBridge, Lambda) and relational platforms including Oracle, Microsoft SQL Server, IBM Informix, and PostgreSQL.

· Experience delivering within an Agile/Scrum SDLC and tracking work in JIRA and Confluence.

· Familiarity with federal data standards and security controls, including FISMA, FedRAMP Moderate, and NIST SP 800-53.

Pulled from the full job description

• Paid training
• 401(k)
• Health insurance
• Paid time off
• Vision insurance, We offer a competitive benefits package including, but not limited to:
• Competitive salary with performance-based bonus opportunities
• Competitive Paid Time Off
• Training and Certification opportunities eligible for expense reimbursement
• Catered lunches twice a week at the headquarters office in Rockville, MD
• Team building and social activities
• Mentor program to help you develop professionally and personally

IvoryCloud is an Equal Opportunity Employer (EEO).

Pay: $120,000.00 - $155,000.00 per year

Benefits:

• 401(k)
• Health insurance
• Paid time off
• Vision insurance