Senior ETL Engineer
Our client, A large non-profit is seeking a Senior Data ETL Engineer to join their team. As a Senior Data/ETL Engineer, you will be part of the IT Dept supporting business operations. The ideal candidate will have forward thinking, ability to think critically and apply a customer lens which will align successfully in the organization.
Job Title: Senior Data/ETL Engineer
Location: Washington, DC (Hybrid 2X a week)
Pay Range: DOE
What's The Job?
The Senior Data Engineer will execute on implementing business intelligence solutions across all divisions of the organization. The individual in this role will guide the team in design and implementation of each solution and will implement improvements of technical standards, development processes, governance, and technologies.
Essential Duties and Responsibilities
- Serve as a technical lead in the development of business intelligence solutions. Coordinate with scrum masters / project managers on optimizing scheduling, work allocations, and story assignments.
- Manage reporting environment including data sources, connections, security, subscriptions and metadata.
- Assist in initiative towards data access control and integrity across the enterprise.
- Create data models and schema for reliable and highly performant data marts and data warehouse.
- Develops complex ETL (extract, transform and load) SQL scripts to gather data from various databases and systems to make data available for enterprise analytics and reporting.
- Evaluate, test and implement new or upgraded software.
- Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution.
- Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports.
- Identify areas for improvement within the EDS organization related to architecture, design, performance optimization, development process, workflows, governance, tools/technologies.
- Conduct end user training on data solutions
What’s in it for me?
Education, Experience and Skills:
- Bachelor Degree and/or relevant technical training with no preferred certification.
- Over 8-10 years of experience in the field of Information Technology with proficiency in ETL design/ development and Data Warehouse Implementation/development
- Experienced in Design, Development and Implementation of large - scale projects in Financial, Shipping and Retail industries using Data Warehousing ETL tools (Pentaho)
- Knowledge about Software Development Lifecycle (SDLC), Agile, CI/CD deployment
- Experience in Architecting and building Data Warehouse systems and Business Intelligence systems including ETL using Pentaho BI Suite (Pentaho Data Integration Designer / Kettle)
- Hands on experience on the whole ETL (Extract Transformation & Load) process
- Experience in creating ETL transformations and jobs using Pentaho Kettle Spoon designer and Pentaho Data Integration Designer and scheduling
- Used various steps in Pentaho transformations including Row Normalizer, Row Demoralizer, Database Lookup, Database Join, Calculator, Add Sequence, Add Constants and various types of inputs and outputs for various data sources including Tables, Access, Text File, Excel and CSV file
- Integrating Kettle (ETL) with Hadoop and other various NoSQL data and loaded unstructured data into Hadoop File System (HDFS)
- Experience in performing Data Masking/Protection using Pentaho Data Integration (Kettle)
- Strong development experience in writing PL/SQL Stored Procedures, Functions, packages and debugging the code
- Strong development experience working with Columnar DBs preferably HP Vertica
- Strong expertise in Developing and Debugging MSSQL or PostgreSQL SQL scripts, functions, stored procedures, views, complex SQL queries, cursors, and triggers
- Expertise in Performance tuning, Query optimization and exception handling
If this is a role that interests you and you’d like to learn more, click apply now and a recruiter will be in touch with you to discuss this great opportunity. We look forward to speaking with you!
About ManpowerGroup, Parent Company of: Manpower, Experis, Talent Solutions, and Jefferson Wells
ManpowerGroup® (NYSE: MAN), the leading global workforce solutions company, helps organizations transform in a fast-changing world of work by sourcing, assessing, developing, and managing the talent that enables them to win. We develop innovative solutions for hundreds of thousands of organizations every year, providing them with skilled talent while finding meaningful, sustainable employment for millions of people across a wide range of industries and skills. Our expert family of brands – Manpower, Experis, Talent Solutions, and Jefferson Wells – creates substantial value for candidates and clients across more than 75 countries and territories and has done so for over 70 years. We are recognized consistently for our diversity - as a best place to work for Women, Inclusion, Equality and Disability and in 2022 ManpowerGroup was named one of the World's Most Ethical Companies for the 13th year - all confirming our position as the brand of choice for in-demand talent.