PRIMARY FUNCTION
The Senior Data Engineer is responsible for architecting and implementing reliable, scalable ELT/ETL workflows that support enterprise-wide data needs. This role requires deep expertise in data analysis, data modeling, and the design of complex ELT pipelines that enable efficient data integration and analytics.
The Senior Data Engineer collaborates closely with cross-functional teamsโincluding data analysts, data scientists, product managers, and business stakeholdersโto define requirements, drive technical discussions, and develop high-quality data solutions. Additionally, this role is expected to clearly communicate technical concepts, translate complex data challenges into actionable business insights, and guide teams toward best-practice data engineering approaches.
ย
ESSENTIAL DUTIES AND RESPONSIBILITIES
This list may not include all of the duties that may be assigned.
1)Design, build, and maintain scalable, reliable ELT/ETL pipelines using modern data engineering tools and frameworks.
2)Architect and optimize data models, schemas, and data platforms to support both analytical and operational workloads.
3)Design, document, and maintain enterprise-level data models (conceptual, logical, and physical) using data modeling best practices.
4)Collaborate with cross-functional teams to understand requirements, define data strategies, and deliver high-quality engineering solutions.
5)Lead and drive technical discussions, solution design, and architectural decisions across teams.
6)Implement and enforce comprehensive data quality standards, validation rules, and monitoring frameworks to ensure accuracy, consistency, completeness, and reliability across all data assets.
7)Develop efficient, well-structured SQL and complex data transformation logic to support analytics and reporting.
8)Monitor, troubleshoot, and enhance data pipelines for performance, reliability, and cost efficiency.
9)Ensure data security, compliance, and adherence to best practices across cloud and on-premise data systems.
10)Communicate complex technical topics in a clear, business-aligned manner to stakeholders at all levels.
11)Mentor and guide junior and mid-level engineers, contributing to team growth and engineering excellence.
ย
QUALIFICATIONS
EDUCATION: Bachelorโs degree in related field required. Masterโs degree preferred.
ย
EXPERIENCE:
โข10+ years of experience in data engineering or a related field required.
โขExpert-level proficiency in SQL and experience with data transformation tools (e.g., Azure Data Factory, Apache Spark, Glue) required.
โขProven experience architecting and maintaining large-scale ELT/ETL pipelines in cloud environments (AWS, Azure, or GCP) required.
โขDeep understanding of data modeling concepts (dimensional modeling, star schema, normalization) required.
โขHands-on experience with modern data warehousing platforms, preferably Databricks/Snowflake/Azure Synapse required.
โขExperience in DevOps activities, including CI/CD integration using Databricks Asset Bundles (DABs) required.
โขStrong programming skills in Python or another modern scripting language required.
ย
KNOWLEDGE, SKILLS AND ABILITIES
โขDemonstrated ability to translate complex business requirements into scalable, high-impact technical solutions.
โขExcellent communication, documentation, and stakeholder engagement skills.
โขProficient in building Power BI data models and creating effective dashboards.
โขDemonstrated ability to translate complex business requirements into scalable, high-impact technical solutions.
โขExcellent communication, documentation, and stakeholder engagement skills.
โขProficient in building Power BI data models and creating effective dashboards.
ย
TYPICAL WORKING CONDITIONS
โขFull time remote/telework
OTHER PHYSICAL REQUIREMENTS
โขVision
โขSense of sound
โขSense of touch