Sr. Data Engineer - Waltham, United States - PDS Tech Commercial

    Default job background
    Description

    Job Description

    Job DescriptionYour next new challenging project is here


    Senior Data Engineer

    Start:

    ASAP

    Location:

    Waltham, MA – must be local to MA or willing to move to MA

    Contract Length:

    6 Month, possible to extend

    Pay:

    per hour (depending on experience)

    Top Skills -

    • ETL Developer with Experience in Matillion (ETL) and Snowflake.
    • Experience in Data warehousing.
    • Strong SQL Skills.

    Job Purpose:
    We are seeking a Senior Data Engineer to join the data and reporting office team (FDRO). The FDRO is responsible for financial data and financial reporting across the breath of COMPANY.

    Day to day you will lead all aspects of the design, development, and delivery of database, business intelligence, data warehouse, and data integration solutions.


    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.


    • Design, develop, and maintain ETL processes using 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 APIs
    • Transform and cleanse data to ensure data quality and integrity
    • Load data into the data warehouse, ensuring data consistency and accuracy
    • Optimize ETL processes for performance, scalability, and reliability
    • Work closely with data architects, analysts, and developers to support data integration initiatives.
    • Implement data validation, data quality checks, and data security measures
    • Troubleshoot 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.

    Requirements:


    • A minimum of 4 years of experience with relational databases, ETL, and data warehouse required.
    • Expert level knowledge of industry leading ETL/ELT tools such as 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 six years of related experience, or Master's degree in Computer Science or a related field with at least 4 years of related experience required.
    • Ability to work with different functional groups and levels of employees to effectively and professionally achieve results.
    • Strong organizational skills; ability to accomplish multiple tasks within the agreed upon timeframes through effective prioritization of duties and functions in a fast-paced environment.

    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 Databases
    • Knowledge of data visualization tools, such as Power BI or Tableau.
    Pay Details: 65.00 to 80.00 per hour


    Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and a 401K plan.

    Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs.

    In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable.

    Equal Opportunity Employer/Veterans/Disabled

    To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to


    The Company will consider qualified applicants with arrest and conviction records subject to federal contractor requirements and/or security clearance requirements.

    Company DescriptionSince 1977, the PDS family of companies has become among the largest and most respected staffing companies in the United States.

    A vital part of the PDS family, PDS Tech Commercial connects highly skilled employees with Fortune 500 clients' needs for project support such as contingent labor, statement of work/offload engineering projects, and permanent placements.

    PDS Tech Commercial has staffing partnerships with leading organizations based in the United States and globally.

    We hire jobseekers daily for openings across skill categories, including Engineering, IT, Business Professional, Administrative, Accounting/Finance, Skilled Trades and Industrial.

    We offer eligible associates an ala carte benefits package, that can include direct deposit, free career counseling, 401(k), select paid holidays, short-term disability insurance, skills training, employee referral bonuses, and an affordable medical coverage plan.

    Now part of The Adecco Group, our shared synergies combined with the investment Adecco continues to make in PDS offers significant advantages to both clients and associates alike.

    We share Adecco's dedication to unlocking our Associates' potential by unleashing the and to the importance of human and labor rights, diversity and inclusion, environmental responsibility, and more.

    Company Description

    Since 1977, the PDS family of companies has become among the largest and most respected staffing companies in the United States.

    A vital part of the PDS family, PDS Tech Commercial connects highly skilled employees with Fortune 500 clients' needs for project support such as contingent labor, statement of work/offload engineering projects, and permanent placements.

    \r
    \r
    PDS Tech Commercial has staffing partnerships with leading organizations based in the United States and globally.

    We hire jobseekers daily for openings across skill categories, including Engineering, IT, Business Professional, Administrative, Accounting/Finance, Skilled Trades and Industrial.

    \r
    \r

    We offer eligible associates an ala carte benefits package, that can include direct deposit, free career counseling, 401(k), select paid holidays, short-term disability insurance, skills training, employee referral bonuses, and an affordable medical coverage plan.

    \r
    \r

    Now part of The Adecco Group, our shared synergies combined with the investment Adecco continues to make in PDS offers significant advantages to both clients and associates alike.

    We share Adecco's dedication to unlocking our Associates' potential by unleashing the and to the importance of human and labor rights, diversity and inclusion, environmental responsibility, and more.