Design, develop, and maintain scalable and efficient data pipelines to process data from various sources using tools such as Matillion and Databricks
Collaborate with data scientists, analysts, architects and other stakeholders to understand data requirements and translate them into technical solutions
Develop and optimize ETL (Extract, Transform, Load) processes to ensure data quality and integrity
Utilize Snowflake for data warehousing, ensuring efficient data storage and retrieval
Perform data modeling to design and structure databases that support business requirements
Write and optimize SQL queries for data transformation
Ensure data security and compliance with industry standards and regulations
Adhere to and advocate established best practices and design patterns
Document data processes, workflows, and technical specifications
Conduct data analysis to support business insights and decision-making

Requirements

Typically requires a University Degree or equivalent experience and minimum 8 years prior relevant experience, or An Advanced Degree in a related field and minimum 5 years' experience
Experiencing developing and optimizing ETL processes
Experience with Python for data transformation
Proficiency in API integration (REST) and associated exchange security patterns
Experience with cloud platforms, services and tools
The ability to obtain and maintain a U.S. government issued security clearance is required.
U.S. citizenship is required, as only U.S. citizens are eligible for a security clearance.

Benefits

Applicant Tracking System Keywords

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

Hard Skills & Tools

ETLSQLPythondata modelingdata analysisdata pipelinesdata transformationAPI integrationdata warehousingdata security

Soft Skills

collaborationcommunicationproblem-solvingdocumentationadvocacy for best practices