LansingRecruiter Since 2001
the smart solution for Lansing jobs

ETL Engineer

Company: Complete Corporate Solutions
Location: Dimondale
Posted on: April 10, 2021

Job Description:

Job Title: ETL EngineerForecasted Start Date:Forecasted Start Date = May 17th 2021Official Worksite Address: MSP Headquarters - 7150 Harris Dr Dimondale, MI 48821Working Location: Combination of on-site and remote work defined by future DTMB and CIP direction/guidelines and agreed to by the Hiring Manager.This role will primarily be responsible for designing, developing and implementing data transfer programs (a.k.a. mechanisms, jobs, routines) commonly referred to as Extract-Transform-Load (ETL) across various source systems and loading data into a centralized repository (which is currently a department level database/data mart). Secondarily, this resource will be responsible for assisting in the production of a variety of security and compliance related reports, dashboards, metrics and Key Performance Indicators (KPI's) for Cybersecurity and Infrastructure Protection leadership and related DTMB offices as well as Agency Leaders. An ideal candidate is very strong in ETL, has solid knowledge of data architecture concepts, and also has material experience in report development, specifically using PowerBI.Primary ETL Engineer resource responsibilities:Actively participate and collaborate with the project team, report requestors and end usersUnderstand the data requirements from user requests, documentation and JAD sessionsRecommend approaches and solutions to solve data challengesDesign ETL jobs to meet data requirementsProduce design and testing documentationDevelop and Test ETL jobs (currently Python and PowerShell are the preferred development language for ETL)Collaborate very closely with Report Developers to meet report requestor and end user data needsManage and monitor ETL jobs using Microsoft SQL Server Management StudioImplement ongoing improvements and necessary changes to ETL jobs (i.e. source system changes)Tune ETL jobs to improve performance and efficiencySecondary ETL Engineer (Report Developer) resource responsibilities:Consume audience requirements and translate those into prototypes and wireframe designsCollaborate with team and stakeholders iteratively to develop PowerBI operational reports, Risk Management Scorecards, and dashboards for Executive and Agency Level leadership.Design, develop and implement the report delivery mechanisms, including but not limited to, O365 Integration (SharePoint, Teams, etc.), Mobile, PDF tools/integration, etc.Ability to deliver data and reporting in various capacities including project level work efforts, day to day operational reporting and ad hoc requests from management/leadershipAccordingly, follow the State of Michigan's Project and Software Delivery Processes (SUITE and SEM)Develop necessary and agreed upon documentation and artifacts to support the reporting platform in an operational statePlease complete the table below for any requested skills or certifications that are requested of this resource:1Experience in Information TechnologyRequired72Experience in Business Intelligence/Data Warehousing/AnalyticsRequired53Experience using an industry recognized ETL PlatformRequired54Experience using an industry recognized programing language/scripting language to develop ETL jobsRequired55Recent (last 12 months) experience designing, developing and implementing ETL jobsRequired36Hands on and practical experience in data architecture and designRequired37Hands on and practical experience in administering a database management systems (i.e. DBA experience)Required38Hands on and practical experience in Microsoft SQL Server Management StudioRequiredJob Requirements:kanban, ETL, business intelligence, DBA, Dashboards

Keywords: Complete Corporate Solutions, Lansing , ETL Engineer, Engineering , Dimondale, Michigan

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other Engineering Jobs

GCP Data Migration Engineer
Description: Who We Are We are Accenture, a global professional services company and a leading partner to the world's major cloud providers, including AWS, Azure, and Google. Our longstanding involvement with cloud (more...)
Company: Accenture Contractor Jobs
Location: Detroit
Posted on: 04/22/2021

Detroit Mechanical Engineering Tutor Jobs
Description: Detroit Mechanical Engineering Tutor Jobs Varsity Tutors is always looking for bright individuals in Detroit who
Company: Varsity Tutors
Location: Detroit
Posted on: 04/22/2021

Telecommute Content Engineer
Description: An online education services provider is searching for a person to fill their position
Company: VirtualVocations
Location: Sterling Heights
Posted on: 04/22/2021

Electronics Engineer
Description: About br br The most secretive of Navy vessels, a submarine requires a select community of specially trained professionals to operate its classified, highly advanced hardware. The Sailors in the Submarine (more...)
Company: US Navy
Location: Highland Park
Posted on: 04/22/2021

Mac Tools Seeking Mechanics - Automotive Technicians - Full Training
Description: Job title: Mac Tools Seeking Mechanics - Automotive Technicians - Full Training Job description: Build a Great Career and a Quality Life with Mac Tools. Feel the freedom and independence of working on (more...)
Company: Mac Tools
Location: Clawson
Posted on: 04/22/2021

R & D Project Engineer
Description: HIROTEC AMERICA is the world's leading comprehensive engineering manufacturing company providing state of the art tooling, engineering services and products to automotive manufactures across the world.Currently, (more...)
Location: Auburn Hills
Posted on: 04/22/2021

Quality Engineer
Description: Job Number: 10353 Group: Cosma International Division: Magna Electric Vehicle Structures Job Type: Permanent/Regular Location: St. Clair Group DescriptionCosma provides a comprehensive range of body, (more...)
Company: Magna International
Location: Saint Clair
Posted on: 04/22/2021

Diesel Technician/Mechanic II
Description: br br What's the Job br Ready to move your career forward As a Technician II at Penske, you'll do exactly that. Here, you'll perform preventative maintenance and repairs of all levels on the (more...)
Company: Penske
Location: Plymouth
Posted on: 04/22/2021

Quality Engineer - Tier I Automotive
Description: Job DescriptionQuality Engineer By joining JAC Products as a Quality Engineer QE at our Saline, MI facility, you will have the opportunity to work with a cohesive team and work to meet customer expectations (more...)
Company: JAC Products
Location: Saline
Posted on: 04/22/2021

Sales Engineer
Description: About the positionCapture 3D represents the industry leading ZEISS GOM ATOS 3D non-contact measurement and inspection solutions in fully automated and manual configurations. We are seeking an energetic (more...)
Company: Capture 3D, Inc.
Location: Detroit
Posted on: 04/22/2021

Log In or Create An Account

Get the latest Michigan jobs by following @recnetMI on Twitter!

Lansing RSS job feeds