Senior Data Engineer

Job Summary

We are seeking an energetic and highly skilled Senior Data Engineer to join our dynamic data team. In this pivotal role, you will lead the design, development, and optimization of large-scale data systems that empower data-driven decision-making across the organization. Your expertise in cloud platforms, big data technologies, and data modeling will drive innovative solutions that enhance our data management and analytics capabilities. This position offers an exciting opportunity to work with cutting-edge tools and collaborate across departments to deliver scalable, reliable, and efficient data pipelines.

Duties

• Design, develop, and maintain robust ETL (Extract, Transform, Load) pipelines utilizing tools like Informatica, Talend, and custom Python scripts to ensure seamless data flow across systems.
• Architect and optimize data warehouses using dimensional modeling principles to support business intelligence and analytics initiatives.
• Manage and enhance big data systems leveraging Hadoop ecosystem components such as Apache Hive, Spark, and Azure Data Lake for scalable data processing.
• Develop and implement data models for linked data integration, ensuring consistency and accuracy across diverse datasets.
• Collaborate with cross-functional teams to gather requirements, translate business needs into technical specifications, and deliver scalable cloud-based solutions on AWS, Azure, or other public cloud platforms.
• Write complex SQL queries for query management, reporting, and analysis using Microsoft SQL Server, Oracle, or cloud databases.
• Support the deployment of RESTful APIs for data access and integration purposes while adhering to best practices in software development and API security.
• Participate in Agile development cycles to continuously improve data infrastructure, troubleshoot issues promptly, and implement enhancements efficiently.
• Conduct analysis to identify opportunities for process improvements in data management workflows and support model training activities for advanced analytics initiatives.

Experience

• Proven experience as a Data Engineer working with large-scale big data systems such as Hadoop, Spark, or similar frameworks.
• Extensive knowledge of cloud-based data storage solutions including AWS (Amazon Web Services), Azure Data Lake, or equivalent public cloud services.
• Strong programming skills in Java and Python for developing scalable ETL pipelines and automation scripts.
• Hands-on experience with SQL databases like Microsoft SQL Server, Oracle, or cloud-based SQL services; proficiency in database design and dimensional modeling is essential.
• Familiarity with business intelligence tools such as Looker or similar platforms for creating dashboards and reports.
• Demonstrated expertise in data modeling techniques including linked data concepts and schema design for complex datasets.
• Experience working with ETL tools like Talend or Informatica to streamline data integration processes.
• Knowledge of shell scripting (Bash/Unix shell) for automation tasks within Linux environments is preferred.
• Ability to work effectively within Agile teams while managing multiple priorities in a fast-paced environment.
• Strong analysis skills with a focus on delivering insights through well-designed data models and efficient query management.

Join us to be part of a forward-thinking organization where your skills will shape the future of our enterprise data landscape!

Pay: $116,000.00 - $141,000.00 per year

Benefits:

• Employee assistance program

Work Location: In person