Job description

Data Engineer/Analyst

Job Summary

Purpose and Scope

We are seeking to hire a detailed oriented data professional to join our Information Management team as a Data Engineer. The Data Engineer will be responsible for expanding, enhancing, and maintaining data warehouse and related infrastructure for effective utilization by internal and external stakeholders. The position will report to the Manager of Business Intelligence and be a vital partner in implementing the a broader data strategy. The role involves data warehouse management (including SQL-based programming to structure data flows and data sources, providing input on data architecture, as well as managing the ETL process, automated data flows, error handling, and other related tasks), and working closely with other members of the Information Management and Technology teams team to promote effective data utilization.

This individual will ensure a positive end-user experience, application availability, and address errors efficiently, as well as oversee the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality.

The work schedule for this position is Monday thru Friday, 9:00AM to 5:00PM. This position would be expected to follow a hybrid model of reporting to work that combines in-office workdays (dowtown Boston) and work from home days as needed.

Duties & Responsibilities

Principal Duties and Responsibilities


Design, develop, and document ETL processes, technical architecture, data pipelines, and performance

Develop integration process data flows and data mapping analyses

Address application and data-related problems regarding systems integration, compatibility, and multiple-platform integration

Develop and promote data integration methodologies and standards

Develop and implement key components as needed to create testing criteria to guarantee the fidelity and performance of application and data architecture

Identify and develop opportunities for code and data reuse, migration, or retirement of systems.

Work independently and collaboratively to identify issues, perform root-cause analysis that would lead to proper and timely issue resolutions

Take ownership over data flow errors, communicating about them and working to resolve them as efficiently as possible

Establish methods and procedures for tracking data quality, completeness, redundancy, and improvement

Work closely with the rest of the Business Intelligence team and other internal stakeholders to understand the needs of the business and build data resources to best meet those needs

Minimum Requirements & Qualifications

Minimum Education

Bachelor's Degree in Computer Science, Information Systems, Business Administration or other related field, or equivalent work experience

Required Experience

Minimum Experience and Required Skills

Minimum of Three (3) plus years of experience working within an Application or Database Production support role

Minimum of Three (3) plus years of experience with scripting and object-oriented programming languages

Minimum of Three (3) plus years of Relational Database experience

Three (3) years of experience in data engineering or a related role

Experience using ETL tools in a data analyses, data engineering, or similar role

Business Intelligence (BI) knowledge; ideally with three (3) years of exposure to BI from an ETL perspective

Demonstrable experience SQL and core data management principles (such as ETL/ELT, data warehousing architecture, query design, and performance tuning)

Experience defining/modeling/implementing an Enterprise Data Warehouse using best practices

Experience with database schema, objection management, data modeling & architecture, and data warehouse design

Experience with interactive reporting platforms (Tableau, Power BI, etc.)

Proven track record of self-starting and growth in related field(s)

Developing and maintaining formal documentation that describes data and data structures including data modelling

Superior attention to detail skills and an ability to think critically and conceptually

Team oriented and flexible with proven track record in collaborating with multiple stakeholders

Strong verbal and written skills

Ability to quickly learn new technologies

Preferred Experience And Required Skills

At least 6 years of DWH experience

At least 6 years of ETL development experience

At least 3 years of Cloud based technological experience

Proficiency with interactive reporting platforms (Tableau, Power BI, etc.).

Proven success with documentation of processes, distributing to end-users and supporting those users.

5+ years' experience with advanced data management systems (e.g., PostgreSQL, etc.)

Deep expertise in data modeling and structuring using Python/R

Experience with systems migration experience is highly desirable

Experience in high volume data environments

Please let the company know that you found this position on this Job Board as a way to support us, so we can keep posting cool jobs.