Senior Data Engineer

Senior Data Engineer

The Senior Data Engineer is responsible for leadership and expertise in developing, maintaining, and optimizing data pipelines and infrastructure to ensure the availability, accuracy, and reliability of data for various business functions. This role extends beyond foundational engineering tasks to include leadership, strategic architecture contributions, and advanced integration of cloud and AI/ML technologies. The Senior Data Engineer ensures high-quality data availability for analytics, reporting, and machine learning initiatives across the organization.

Principal Duties and Responsibilities:

• Design, build, and maintain scalable and efficient data pipelines across structured and unstructured data sources.
• Develop and optimize complex SQL queries, stored procedures, and SSIS packages to support data transformation and integration.
• Collaborate with data architects and analysts to design robust data models and schemas for analytics and reporting.
• Integrate data from diverse sources (databases, APIs, streaming platforms) into unified, high-quality datasets.
• Automate data workflows and implement monitoring, validation, and testing processes to ensure data integrity and reliability.
• Support the deployment and operationalization of AI/ML models in collaboration with data scientists.
• Optimize data storage and retrieval mechanisms using cloud-native tools and frameworks.
• Identify opportunities for data-related process improvements and work with cross-functional teams to implement them.
• Document data engineering processes, architecture, and best practices.
• Evaluate and recommend new tools and technologies to improve the efficiency and effectiveness of data engineering.
• Mentor data engineers and contribute to team knowledge sharing and continuous improvement.
• Stay updated with emerging trends and technologies in data engineering and adopt best practices to continuously improve the data infrastructure.

Requirements:

• A minimum of 7 years of experience in data engineering, with a strong focus on cloud environments is required.
• Experience with AWS is highly preferred.
• Exceptional SQL skills, including experience with SSIS, stored procedures, and data modeling.
• 3+ years of experience working with AI/ML technologies, including model deployment and integration.
• 3+ years of experience with data lake and data warehouse architectures.
• Proficiency in Python, Spark, and other modern data processing frameworks.
• Proven experience in building and automating data pipelines and ETL/ELT processes.
• Strong understanding of data quality, validation, and performance optimization techniques.
• Familiarity with cloud data platforms such as Snowflake, Redshift, or Databricks.
• Excellent communication and collaboration skills to work effectively with cross-functional teams.
• Attention to detail and a commitment to ensuring data quality and accuracy.

Our comprehensive benefits package includes all traditional offerings such as:

• Health Insurance options, Dental Insurance options and Vision Insurance
• Employee Life Insurance/AD&D and Dependent Life Insurance options
• Short-term & Long-term Disability
• Health Savings Account with potential employer match
• Flexible Medical and Dependent Care Account
• Accident Insurance
• Critical Illness Insurance
• Employee Assistance Program
• Legal/Identify Theft Insurance options
• Long Term Care Insurance
• Pet Insurance
• 401 (k) Retirement Plan with match up to 5%, plus profit sharing & discretionary contributions (subject to vesting)
• 5 weeks of Paid Time Off (PTO)
• 11 paid holidays

We also offer other benefits to help foster a healthy, balanced lifestyle such as:

• Flextime schedules
• Paid Parental Leave
• Student loan paydown and refinancing assistance
• Educational assistance for job related courses, seminars, certifications or degrees
• One paid day every year to volunteer for your non-profit of choice
• On-site fitness center (Maine) or fitness reimbursement
• Subsidized parking
• Sit-Stand desks & daily stretch breaks

MEMIC is committed to a policy of nondiscrimination and equal opportunity for all employees and qualified applicants without regard to race, color, religious creed, national origin, ancestry, age, disability, genetics, gender identity, veteran's status, sexual orientation, or any other characteristic protected by law. MEMIC is an equal opportunity employer encouraging diversity in the workplace.