March 19, 2023
Apply Now
Boston, MA, United States
March 19, 2023
Apply NowJob 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
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
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
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
