Sr. Data Engineer

We’re ALTEN Technology USA, an engineering company that provides solutions for engineering, technology, and product development projects. For decades, we’ve been helping our clients develop products that are changing the world, whether that’s by shaping the future of space exploration, saving lives with medical devices that set a new standard of care, or creating the fully autonomous electric taxi of tomorrow. Our team of more than 600 people works across industries including aerospace, medical devices and life sciences, unmanned systems and robotics, automotive OEM and tier 1 suppliers, commercial vehicle, electric vehicles, rail, and more. Our offices across the US have different industry focuses and engage with our clients in different ways, ranging from working on-site at client facilities to performing product development at our delivery centers.
 
ALTEN Group, our parent company, has been a leader in engineering and information technology for more than 30 years. ALTEN Group operates in 30 countries across Europe, North America, Asia, Africa and the Middle East and employs more than 36,000 people, 88% of whom are engineers. The company covers the whole development cycle and offers a choice of service levels, from technology consulting to complete project outsourcing.
 
When you join ALTEN Technology USA, you join a group of people passionate about collaborating to solve some of the world’s most technical engineering challenges. Our success is tied to taking care of our employees by building relationships and providing opportunities for mentorship and career growth. We offer comprehensive benefits for all full-time employees, including medical, dental, and vision insurance; a 401(k) plan with employer matching; paid time off (PTO); paid parental leave; and mentorship to help you take your career to the next level. You don’t have to take our word for it that we are a great place to work—we were named on the 2023 Top Workplaces list thanks to feedback from our proud employees.

As a Sr. Data Engineer you will be responsible for:

Essential Duties and Responsibilities include the following. Other duties may be assigned.

• Collaborate with stakeholders, Product Owners, and Leads to resolve data-related technical issues and support data infrastructure needs.
• Develop and maintain optimal data pipelines, assembling large, complex data sets to meet business requirements.
• Identify, design, and implement internal process improvements, automate manual processes, optimize data delivery, and redesign infrastructure for scalability.
• Migrate on-premises data servers to cloud data platforms using AWS and Snowflake.
• Build data pipelines by extracting, transforming, cleansing, and loading data from various sources using Snow procedures, JavaScript, Python, and PySpark.
• Develop data pipelines to provide actionable insights into customer acquisition, operational efficiency, and other critical business performance metrics.
• Assemble extensive, complex data sets to meet business requirements.
• Implement internal process improvements, including infrastructure redesign for scalability, optimizing data delivery, and automating manual processes.
• Develop the necessary infrastructure for optimal extraction, transformation, and loading of data from various sources using AWS and SQL technologies.
• Work with stakeholders, including data, design, product, and executive teams, to resolve data-related technical issues.

Required Skills –

• Bachelor’s degree with over 10 years of professional IT experience.
• More than 6 years of extensive experience in Data Engineering using Snowflake, Snow Procedure, SQL/PLSQL, JavaScript, and Python.
• Over 7 years of experience with SQL and PLSQL procedures.
• Proficient in data modeling and dimensional modeling.
• Experienced in the full lifecycle of Data Warehouse projects.
• Skilled in designing and developing data models and writing complex Snow procedures, JavaScript, and SQL queries for data extraction, manipulation, and analysis.
• Familiar with using Git, Visual Studio Code, and managing code check-in and check-out processes.
• Experience with Airflow for orchestration of AWS and Snowflake workflows.
• Knowledge and exposure to AWS and Snowflake are advantageous.
• Competent in constructing Snowflake data pipelines using Snow pipes, Snow streams, Snow Procedures, DBT, JavaScript, etc.

Preferred Skills (not required) –

• Certifications in Cloud Applications, Databases, Data Integration, or Business Intelligence Applications.
• Familiarity or experience with BI and Analytical applications like Qlik Sense, Microsoft Power BI, or Tableau.
• Exposure to programming knowledge, data streaming, and data processing and development experience.

Salary Range: $95,000 – $110,000

ALTEN Technology is an Equal Opportunity Employer. Our Policy is to extend opportunities to qualified applicants and employees on an equal basis regardless of an individual’s age, race, color, sex, religion, national origin, disability, sexual orientation, gender identity/expression or veteran status.