Job Details
Experience Needed:
Career Level:
Education Level:
Salary:
Job Categories:
Skills And Tools:
Job Description
Role Summary:
A Senior Data Engineer is responsible for building and maintaining data systems, constructing datasets that are easy to analyze and support company requirements. Senior data engineers provide hands-on coding with the ability to outline solution design with coding best practices and perform code reviews.
The Senior Data Engineer is responsible for overseeing junior data engineering activities and aiding building the business’ data collection systems and processing pipelines. The role of the Senior Data Engineer is responsible for building and maintaining optimized and highly available data pipelines that facilitate deeper analysis and reporting by the Data and Analytics department.
Primary Responsibilities:
- Data Pipeline Development: Design, develop, and maintain scalable ETL/ELT data pipelines for structured and unstructured data.
- Database Optimization: Collaborate with engineers to optimize database schemas and ensure efficient query performance.
- Data Governance & Security: Implement data governance best practices, ensuring compliance with HIPAA, GDPR, and industry regulations.
- Data Architecture: Develop data warehouse and data lake solutions to support analytics and machine learning workloads.
- Automation & Integration: Automate data processes using Python, SQL, or Spark, integrating with cloud platforms like Azure, AWS, or GCP.
- BI & Analytics Support: Work closely with BI & analytics teams to support dashboarding and reporting needs.
- Monitoring & Troubleshooting: Ensure high data pipeline performance, troubleshoot issues, and implement proactive monitoring.
- Metadata Management: Establish data cataloging, metadata management, and lineage tracking for better data governance.
Job Requirements
- Experience: 5+ years in Data Engineering, ETL development, or Database Architecture.
- Data Modeling & Governance: Strong understanding of data modeling, governance, and performance tuning.
- BI & Reporting Tools: Advanced experience with Power BI, SSIS, SSRS, SSAS.
- SQL & Programming: Expertise in SQL, Python, or Scala, with hands-on experience in big data frameworks (Spark, Hadoop, Snowflake).
- Cloud Data Services: Experience with Azure Data Factory, AWS Glue, or GCP Dataflow.
- Orchestration & CI/CD: Familiarity with workflow orchestration tools like Airflow, Prefect, or Dagster, and CI/CD pipelines using Git.
- Modern Data Warehousing: Hands-on experience with Redshift, BigQuery, or Azure Synapse.
- Troubleshooting & Debugging: Strong analytical skills for resolving database integrity, performance, and security issues.
- Technical Leadership: Experience in mentoring junior developers and enforcing best practices in data engineering.
- Communication Skills: Ability to explain technical concepts to technical and non-technical audiences.
- (Preferred) Experience in healthcare data and regulatory standards (HIPAA, HL7)