Sr. Data Engineer

3 weeks ago

Troy, United States Flagstar Bank Full time

The Sr. Data Engineer is responsible in understanding and supporting the businesses through the design, development, and execution of Extract, Transform, and Load (ELT/ETL), data integration, and data analytics processes across the enterprise. He/She will stay on top of tech trends, experiment with and learn new technologies, contribute to the growth of data organization, participate in internal & external technology communities, and mentor other members of the team. Provide technical leadership at every stage of the data engineering lifecycle, from designing data platforms, data pipelines, data stores, and gathering, importing, wrangling, querying, and analyzing data. The Sr data engineer will work closely with various customers including their immediate project teams, business domain experts and other technical staff members. Work daily within a project team environment, taking direction from project management and technical leaders. Responsible for design, development, administration, support, and maintenance of the Snowflake Platform and Oracle Platform. Participates in the full systems life cycle and cloud data lake/data warehouse design and build including recommendation of code development, integration with data marketplace or reuse and buy versus build solutions.

  • Technical Leadership –Lead data integration across the enterprise thru design, build and implementation of large scale, high volume, high performance data pipelines for both on-prem and cloud data lake and data warehouses. Lead the development and documentation of technical best practices for ELT/ETL activities. Also, oversee a program inception to build a new product if needed.
  • Solution Design – Lead the design of technical solution including code, scripts, data pipelines, processes/procedures for integration of data lake and data warehouse solutions in an operative IT environment.
  • Code Development – Ensures data engineering activities are aligned with scope, schedule, priority and business objectives. Oversees code development, unit and performance testing activities. Responsible to code and lead the team to implement the solution.
  • Testing – Leads validation efforts by verifying the data at various middle stages that are being used between source and destination and assisting others in validating the solution performs as expected. Meets or exceeds all operational readiness requirements (e.g., operations engineering, performance, and risk management)
  • Ensure compliance with applicable federal, state and local laws and regulations.  Complete all required compliance training.  Maintain knowledge of and adhere to Flagstar's internal compliance policies and procedures.  Take responsibility to keep up to date with changing regulations and policies.

Job Requirements:

  • High School Diploma, GED, or foreign equivalent required.
  • Bachelor's in Computer Science, Mathematics or related field + 7 years of development experience preferred, or 10 years comparable work experience required.
  • 10 years of experience designing, developing, testing, and implementing Extract, Transform and Load (ELT/ETL) solutions using enterprise ELT/ETL.
  • 15 years of comparable work experience.
  • 10 years of experience developing and implementing data integration, data lake and data warehouse solutions in an on-premise and cloud environment.
  • 5 years of experience working with Business Intelligence tools (IBM Cognos is preferred), Power BI and Alteryx.
  • 7 years of experience working with API’s, data as a service, data marketplace and data mesh.
  • 10 years of experience with various Software Development Life Cycle methods such as Agile, SCRUM, Waterfall, etc.
  • 3-year experience in 100+ TB data environment.
  • Proven experience developing and maintaining data pipelines and ETL jobs using IBM DataStage, Informatica, Matillion, FiveTran, Talend or Dbt.
  • Knowledge of AWS cloud services such as S3, EMR, Lambda, Glue, Sage Maker, Redshift & Athena and/or Snowflake.
  • Experienced in data modelling for self-service business intelligence, advanced analytics, and user application.
  • Experience with Data Science including AI/ML Engineering, ML framework/pipeline build and predictive/prescriptive analytics on Aws Sagemaker.
  • Experience with migrating, architecting, designing, building and implementing cloud data lake, data warehouses (cloud/on-prem), data mesh, data as a service, and cloud data marketplace.
  • Ability to communicate complex technical concepts by adjusting messaging to the audience: business partners, IT peers, external stakeholders, etc.
  • Proven ability to design and build technical solutions using applicable technologies; ability to demonstrate exceptional data engineering skills.
  • Ability to prioritize work by dividing time, attention and effort between current project workload and on-going day to day activities.
  • Demonstrates strength in adapting to change in processes, procedures and priorities.
  • Proven ability to establish a high level of trust and confidence in both the business and IT communities.
  • Strong teamwork and interpersonal skills at all management levels.
  • Proven ability to manage to a project budget.
  • Experience applying agile practices to solution delivery.
  • Must be team-oriented and have excellent oral and written communication skills.
  • Strong analytic and problem-solving skills.
  • Good organizational and time-management skills.
  • Experience in Strategic Thinking and Solutioning.
  • Must be a self-starter to understand existing bottlenecks and come up with innovative solution.
  • Demonstrated ability to work with key stakeholders outside the project to understand requirements/resolve issues.
  • Experience with data model design, writing complex SQL queries, etc., and should have a good understanding of BI/DWH principles.
  • Expertise in Relational Database Management System, Data Mart and Data Warehouse design.
  • Expert-level SQL development skills in a multi-tier environment.
  • Expertise in flat file formats, XML within PL/SQL, and file format conversion.
  • Strong understanding of SDLC and Agile Methodologies.
  • Strong understanding of model driven development.
  • Strong understanding of ETL best practices.
  • Proven strength in interpreting customer business needs and translating them into application and operational requirements.
  • Strong problem-solving skills and analytic skills with proven strength in applying root cause analysis.

  • Sr. Data Engineer

    18 hours ago

    Troy, United States Flagstar Bank Full time

    Position Title Sr. Data Engineer Location Headquarters-Troy, MI Job Summary The Sr. Data Engineer is responsible in understanding and supporting the businesses through the design, development, and execution of Extract, Transform, and Load (ELT/ETL), data integration, and data analytics processes across the enterprise. He/She will stay on top of tech trends,...

  • Sr. Technology Risk Engineer

    1 week ago

    Troy, Michigan, United States Flagstar Bank Full time

    Position Title Sr. Technology Risk Engineer Location Headquarters-Troy, MI Job Summary The Sr Technology Risk Engineer is responsible for the delivery of the program elements of all first line of defense risk activities directly or indirectly impacting Information Technology and Information Security within Flagstar. The Sr Information Technology Risk...

  • Sr. Occupant Protection CAE Engineer

    2 weeks ago

    Troy, United States Altair Full time

    Transforming the Future with Convergence of Simulation and Data Sr. Occupant Protection CAE Engineer Job Summary: Our client in Troy, MI is looking for a Sr. Occupant Protection CAE Engineer. This is a contract position. The Sr. Occupant Protection CAE Engineer will develop CAE models for occupant protection virtual analysis. This engineer will be...

  • Sr. Occupant Protection CAE Engineer

    3 weeks ago

    Troy, United States Altair Full time

    Transforming the Future with Convergence of Simulation and Data Sr. Occupant Protection CAE Engineer Job Summary: Our client in Troy, MI is looking for a Sr. Occupant Protection CAE Engineer. This is a contract position. The Sr. Occupant Protection CAE Engineer will develop CAE models for occupant protection virtual analysis. This engineer will be...

  • Sr. Technology Risk Engineer

    1 month ago

    Troy, United States New York Community Bank Full time

    Job SummaryThe Sr Technology Risk Engineer is responsible for the delivery of the program elements of all first line of defense risk activities directly or indirectly impacting Information Technology and Information Security within Flagstar. The Sr Information Technology Risk Engineer will leverage experience in business and technical acumen environment to...

  • Sr. Technology Risk Engineer

    3 weeks ago

    Troy, United States New York Community Bank Full time

    Job SummaryThe Sr Technology Risk Engineer is responsible for the delivery of the program elements of all first line of defense risk activities directly or indirectly impacting Information Technology and Information Security within Flagstar. The Sr Information Technology Risk Engineer will leverage experience in business and technical acumen environment to...

  • Sr. Research Engineer

    3 weeks ago

    Troy, Michigan, United States Magna International Full time

    About usWe see a future where everyone can live and move without limitations. That's why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the planet and, above all, people.Forward. For all.Group SummaryMagna is more than one of the world's largest suppliers in the automotive space. We...

  • Sr. Research Engineer

    1 month ago

    Troy, Michigan, United States Magna International Full time

    About usWe see a future where everyone can live and move without limitations. That's why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the planet and, above all, people.Forward. For all.Group SummaryMagna is more than one of the world's largest suppliers in the automotive space. We...

  • Sr. Technology Risk Engineer

    4 weeks ago

    Troy, United States TEKsystems Full time

    Top Skills' Details - 5+ years of IT Risk management experience (know how to plan and conduct risk assessments, identify risk, analyze, and report on them). If they have 3-4 years of experience we can still look at them but the pay rate will be less and they wont have a Sr. title) - Good understanding of compliance and regulations (SOX ITGC, COBIT,...

  • Sr. Technology Risk Engineer

    3 weeks ago

    Troy, United States TEKsystems Full time

    Top Skills' Details - 5+ years of IT Risk management experience (know how to plan and conduct risk assessments, identify risk, analyze, and report on them). If they have 3-4 years of experience we can still look at them but the pay rate will be less and they wont have a Sr. title) - Good understanding of compliance and regulations (SOX ITGC, COBIT,...

  • "Data Engineer"

    2 weeks ago

    Troy, United States Siri InfoSolutions Inc Full time

    Job DescriptionJob DescriptionJob Title: Data Engineer Client: Delta DentalLocation:Okemos,MI-Hybrid 2days onsite /WeekRate:49-50/hr. W2Visa: AnyVendor: TeksystemsRecruiter: Jessica Top Skills' DetailsTop 3 skills after qualifying with the manager: 1) SNOWFLAKE (this is by far the most important for this role), more specifically experience with...

  • Sr. Engineer, Systems

    3 weeks ago

    Troy, United States LG Energy Solution Michigan, Inc. Full time

    Job DescriptionJob DescriptionTitle: Sr. Engineer, Systems Reports to: Systems MangerLocation: Troy, MI LG Energy Solution Michigan Inc. (LGESMI) develops and manufactures large lithium ion polymer batteries and packs for electric vehicle (EV) and energy storage applications. Come join the leader in advanced EV batteries! www.lgenergymi.com Job...

  • Sr. Engineer, Systems

    1 month ago

    Troy, United States LG Energy Solution Michigan, Inc. Full time

    Job DescriptionJob DescriptionTitle: Sr. Engineer, Systems Reports to: Systems MangerLocation: Troy, MI LG Energy Solution Michigan Inc. (LGESMI) develops and manufactures large lithium ion polymer batteries and packs for electric vehicle (EV) and energy storage applications. Come join the leader in advanced EV batteries! www.lgenergymi.com Job...

  • Sr. Engineer, Systems

    4 weeks ago

    Troy, United States LG Energy Solution Michigan, Inc. Full time

    Job DescriptionJob DescriptionTitle: Sr. Engineer, Systems Reports to: Systems MangerLocation: Troy, MI LG Energy Solution Michigan Inc. (LGESMI) develops and manufactures large lithium ion polymer batteries and packs for electric vehicle (EV) and energy storage applications. Come join the leader in advanced EV batteries! www.lgenergymi.com Job...

  • Sr. Engineer, Systems

    3 days ago

    Troy, United States LG Energy Solution Michigan, Inc. Full time

    Job DescriptionJob DescriptionTitle: Sr. Engineer, Systems Reports to: Systems MangerLocation: Troy, MI LG Energy Solution Michigan Inc. (LGESMI) develops and manufactures large lithium ion polymer batteries and packs for electric vehicle (EV) and energy storage applications. Come join the leader in advanced EV batteries! www.lgenergymi.com Job...

  • Data Engineer

    3 weeks ago

    Troy, United States A-Line Staffing Solutions Full time

    Position: Data Engineer Direct Hire Opportunity This is NOT a C2C Position Must be located outside of: TX, TN, or GA Required Experience (must Have) Minimum 5+ years data engineering experience working with designing data models in both column store and relational databases, incorporating disparate data to solve complex business needs. Minimum Bachelors...

  • Senior Project Engineer, Engine and Hybrid Powertrain Development

    1 month ago

    Troy, United States Altair Full time

    Transforming the Future with Convergence of Simulation and Data Senior Project Engineer, Engine and Hybrid Powertrain Development Job Summary: Our client in Auburn Hills, MI is looking for a Senior Project Engineer, Engine and Hybrid Powertrain Development. This is a Contract position. seeking a Sr. Project Engineer with specialization in engine and hybrid...

  • Data Engineer

    1 week ago

    Troy, Michigan, United States TEKsystems Full time

    Data Engineering Specialist at TEKsystemsKnowledge in Data Engineering with DataBricks, Hadoop, and Spark SQL for optimized codeReview and validate BI productsConduct Quick Daily Stand-ups to address team issuesShare knowledge with the teamEnable User Acceptance Testing by supporting Agile Framework and DE/BI deploymentsMaintain version control and...

  • Sr. Research Engineer

    1 month ago

    Troy, United States Magna International Full time

    About us We see a future where everyone can live and move without limitations. That's why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the planet and, above all, people. Forward. For all. Group Summary Magna is more than one of the world's largest suppliers in the automotive space....

  • Sr. Research Engineer

    1 month ago

    Troy, United States Magna International Full time

    About usWe see a future where everyone can live and move without limitations. That's why we are developing technologies, systems and concepts that make vehicles safer and cleaner, while serving our communities, the planet and, above all, people.Forward. For all.Group SummaryMagna is more than one of the world's largest suppliers in the automotive...