Data Engineer

Role Summary

• Design, build, and maintain scalable data solutions that support reporting, self-service analytics, and advanced analytics.
• Work primarily on the organization’s data platform, currently centered on Snowflake and IICS, to transform raw data into trusted, business-ready data assets.
• Partner closely with Data Analysts and source-system teams to translate business needs into data models, pipelines, and reusable data products.
• Use AI-assisted development practices across the full delivery lifecycle to improve design quality, development efficiency, testing, documentation, and technical communication.
• Apply modern data engineering practices while maintaining strong fundamentals in data modeling, ETL/ELT, orchestration, and data quality.

Responsibilities

• Design, develop, and maintain data pipelines, transformations, and orchestration workflows that ingest, curate, and publish data for analytics use cases.
• Build and enhance data models based on business analysis and reporting requirements.
• Work with structured and semi-structured data from enterprise systems and files, including relational databases, JSON, and XML.
• Collaborate with Data Analysts, source-system developers, and business stakeholders to define requirements and deliver fit-for-purpose data solutions.
• Improve engineering productivity by using AI tools for code support, testing framework creation, documentation, diagramming, and solution exploration.
• Support data quality, performance optimization, maintainability, and operational reliability of data solutions.
• Enable business reporting, self-service analytics, and foundational data assets for advanced analytics and data science teams.
• Follow established organizational standards for governance, security, access control, and data handling.

Education, Knowledge, Experience

• Minimum of 5-7 years’ hand-on experience.
• Background in programming, databases, data engineering, analytics engineering, or related technical disciplines; or degree in computer science, software engineering, information systems, economics, or other relevant engineering fields.
• Experience working with data warehousing, data marts, reporting environments, and cloud-based data platforms.
• Experience building ETL/ELT pipelines and supporting analytics-focused data solutions

Functional Competencies

• Knowledge of data and analytics frameworks supporting data lakes, warehouses, marts, and reporting.
• Strong understanding of data modeling principles and the ability to design solutions aligned with business objectives.
• Experience using AI for data engineering tasks such as design support, testing, documentation, structured prompting, and workflow improvement.
• Ability to work across the data lifecycle, from ingestion and transformation through delivery of trusted analytical data sets.
• Understanding of data quality, validation, monitoring, retention considerations, and operational support requirements.
• Ability to balance modern engineering practices with strong core data development fundamentals.
• Strong collaboration and communication skills when working with analysts, developers, and business stakeholders.

Technical Competencies

• Strong SQL and Python skills.
• Hands-on experience with Snowflake and ETL/ELT or data integration platforms; IICS experience is strongly preferred.
• Experience with data orchestration and workflow tools; familiarity with Airflow is a plus.
• Experience with data transformation and modeling tools such as dbt or equivalent frameworks.
• Familiarity with CI/CD practices, version control, and testing approaches for data solutions.
• Experience working with relational databases such as SQL Server and PostgreSQL.
• Ability to work with APIs and semi-structured data formats such as JSON and XML.
• Understanding of cloud and DevOps concepts is a plus.
• Ability to adapt to evolving tools, platforms, and AI-assisted engineering practices.