JOB TITLE : Senior Database Engineer
JOB LOCATION : Waltham, Ma (hybrid Wednesdays onsite)
JOB NUMBER : NGGJP00015825
Wage Range : 65-75 / hr.
REQUIRED EXPERIENCE :
Requirements
- A minimum of 6 years of experience with relational databases, ETL, and data warehouse required.
- Expert level knowledge of industry leading ETL / ELT tools such as ODI, Informatica, Matillion or SSIS.
- Experience in designing and developing complex near real-time and / or batch data integration solutions using cloud based ETL and integration tools
- Experience with traditional and non-traditional forms of analytical data design (Kimbal, Inmon etc)
- Proficiency in SQL programming and relational database concepts.
- Experience with loading and maintaining a data warehouse.
- Bachelor's degree in Computer Science or a related field with 6 years of related experience, or Master's degree in Computer Science or a related field with at least 4 years of related experience required
Nice to Have
Experience with cloud-based data platforms, such as Snowflake.Domain knowledge in the area of finance data is preferred.Experience with SAP Systems and DatabasesKnowledge of data visualization tools, such as PowerBI or Tableau.
JOB DESCRIPTION
Key Accountabilities
A Senior data engineer will be responsible for designing, developing, and maintaining ETL processes to extract, transform, and load data from various sources into our data warehouse. The ideal candidate should have hands-on experience with ETL tools, strong data analysis skills, and the ability to work with large datasets.
Lead the design, development, and maintenance of large-scale data systems, including data warehouses, data lakes, and data pipelines.Design, develop, and maintain ETL processes using tools like Matillion.Design, Develop and maintain optimal data flows in tools like Matillion.Develop and Maintain Datawarehouse objects like tables, views and security roles in snowflake database.Extract data from various sources, such as databases, flat files, and APIsTransform and cleanse data to ensure data quality and integrityLoad data into the data warehouse, ensuring data consistency and accuracyOptimize ETL processes for performance, scalability, and reliabilityWork closely with data architects, analysts, and developers to support data integration initiatives.Implement data validation, data quality checks, and data security measuresTroubleshoot and resolve data issues, performance bottlenecks, and ETL failures.Implement best practices for data warehousing, data modeling, and ETL development.Document ETL processes, data mappings, and configurations.Equal Opportunity Employer, including Veterans and Individuals with Disabilities
While an hourly range is posted for this position, an eventual hourly rate is determined by a comprehensive salary analysis which considers multiple factors including but not limited to : job-related knowledge, skills and qualifications, education and experience as compared to others in the organization doing substantially similar work, if applicable, and market and business considerations. Benefits offered include medical, dental and vision benefits; dependent care flexible spending account; 401(k) plan; voluntary life / short term disability / whole life / term life / accident and critical illness coverage; employee assistance program; sick leave in accordance with regulation. Benefits may be subject to generally applicable eligibility, waiting period, contribution, and other requirements and conditions.
