Lead Data Engineer

Hybrid Role in Boston, MA

Only W2,

No C2C,

We are not able provide Sponsorship

Job description:

• Data Pipeline Development: Design, implement, and maintain robust, scalable, and efficient data pipelines using Jenkins for automated data extraction, transformation, and loading (ETL) processes.

• Relational Database Management: Manage and optimize relational databases (e.g., MySQL, PostgreSQL) to ensure data integrity, availability, and performance for diverse applications and analytical purposes.

• API Integration: Collaborate with software developers to integrate data from various sources through APIs, ensuring seamless data flow between systems and applications.

• Data Modeling and Architecture: Create and maintain data models and data architecture to support analytics and reporting needs, ensuring data consistency and proper documentation.

• Data Analysis and Insights: Utilize Python and RDS to perform advanced data analysis, interpret complex data sets, and deliver actionable insights to key stakeholders and decision-makers.

• Performance Optimization: Identify and resolve performance bottlenecks within data pipelines, databases, and queries to improve system efficiency and response times.

• Data Quality Assurance: Implement data quality checks and validation processes to ensure the accuracy and reliability of data throughout the data ecosystem.

• Data Security and Compliance: Maintain data security standards and compliance with data protection regulations, implementing necessary measures to safeguard sensitive information.

• Collaboration and Communication: Work closely with cross-functional teams, including data scientists, business analysts, and IT, to understand data requirements, develop solutions, and present findings effectively.

Skills:

• Bachelor's degree or relevant experience in Computer Science, Data Science, Information Technology, or a related field. An advanced degree/experience is preferred.

• Proven experience as a Data Engineer, Data Analyst, or a related role with a strong technical background in Jenkins, Relational Databases, APIs, Python, and RDS.

• Solid understanding of data modeling, database design principles, and data warehousing concepts.

• Proficiency in programming languages like Python, SQL, and RDS for data manipulation, analysis, and automation tasks.

• Familiarity with cloud-based technologies, such as AWS, GCP, or Azure, and the ability to leverage cloud services for data management.

• Experience with Jenkins for automated build, test, and deployment processes.

• Strong problem-solving skills and the ability to troubleshoot data-related issues efficiently.

• Excellent communication and collaboration skills to work effectively in a team-oriented environment.

• A passion for data-driven decision-making and a keen eye for detail.

• Knowledge of data visualization tools (e.g., Tableau, Power BI) is a plus.

Cyber Security:

• The client is looking for data-security experience within data engineering, not a traditional cybersecurity role.

• They want someone who has secured cloud-based ETL pipelines, handled IAM/RBAC, protected data in S3 and RDS, secured Jenkins pipelines, and implemented encryption, access controls, and basic compliance practices as part of their data engineering work.

EEO: “Mindlance is an Equal Opportunity Employer and does not discriminate in employment on the basis of – Minority/Gender/Disability/Religion/LGBTQI/Age/Veterans.”