- 6+ Years creating Data Warehouse BI applications including ETL/data mart development, reporting, dashboards and other information analysis and delivery systems.
- Experience with the State of Michigan PMM/SUITE/Agile methodology.
- Experience troubleshooting on all ETL processes and effectively resolve any issues.
- SQL Assistant/Teradata Studio Experience
- Experience in Data Replication using tools like Oracle Golden Gate
- End user training experience.
- Bachelor's degree or equivalent technical study
- 6+ Years Creating Data Warehouse BI applications including ETL/data mart development, reporting, dashboards and other information analysis and delivery systems.
- Experience with the State of Michigan PMM/SUITE/Agile methodology.
- SQL Assistant/Teradata Studio Experience
- Experience in Data Replication using tools like Oracle Golden Gate
- End user training experience.
- Must be able to work independently with little direction.
- Communicate effectively, verbally and in writing, with programmers, analysts, immediate supervisor, management, system users, operations, other State agencies and the private sector.
- Meet with users for clarification and elaboration as may be necessary to clearly define a problem and conceptualize a development plan.
- Recognize, gather, correlate, and analyze facts, draw conclusions, define problems, devise solutions and alternatives and make appropriate recommendations.
- Experience working with Data Modelers and developers, facilitating modification of the logical design to create a physical design most suited to the reporting needs of the customer.
- bility to design applications taking into consideration data reconciliation, (to the source system) query/reporting performance, and analytical business value.
- With the Business Analyst presents the information gathered to the Project Review Board and/or Project Sponsors during project review meetings, project workgroups and to the Technical Review Board providing clarification and answers to questions.
- Consult with agency clients to explain complex IT processes and solutions, developing and maintaining an effective communication plan with DTMB and agency clients relating to project level metrics, bureau level project reporting, etc.
- ssist Architect or DBA to draft technical database model that:
- Gather, review, and analyze potential impacts of changes and inform DTMB management and supported client agencies of impact and risks to existing IT solutions due to proposed legislation, enhancement requests, changes in government requests, changes in governmental processes or procedures.
- Provide professional technical expertise to the DTMB AS PMO Managers and client agency managers and supervisors in IT project estimating, and budgeting.
- Serves as a team lead and resource, directing the code development, providing advice and guidance to other development staff.
- Evaluate and identify opportunities for programming process or tools standardization.
- Perform disaster recovery planning and implementation.
- Provide input to procedures and ensure proper change management for all requested fixes to production systems.
- Review and approve test plans. Incorporate all levels of security, which were identified as system requirements, into test plans.
-
ETL Lead Developer
6 days ago
LanceSoft Michigan Center, United StatesJob Description:Departmental Requirements · Health Care · CareAdvance Application · TWS scheduling · Knowledge of Agile/waterfall Process · Extensive experience with the techniques and ability to work with a variety of individuals and groups in a constructive and collaborative ma ...
-
Mid Level Power BI Developer
6 days ago
CyberTec Michigan Center, United StatesClient would like candidates with 10 years of experience, but not sure they will find that at the rate they are seeking. If I can find good, solid fits that I can clear to submit with 7+ years I will give them a shot. Thanks. · Rate: $50-55/hr C2C (all inclusive) Max · Location: ...
-
Working student
1 week ago
Cascade Innovations Jacksonburg, United StatesEmployment type: Fixed-term; 15 – 20 hours/week · Heading towards the future? Hop on board with Jacksonburg. · How will we communicate, use energy efficiently, and get around in the future? We can work together to find the answers. We are looking for bright minds who can turn th ...
-
Solutions Architect
6 days ago
Snowflake Computing Michigan Center, United StatesBuild the future of data. Join the Snowflake team. · Snowflake Professional Services is the implementation and strategy experts for the Snowflake platform. We engage with customers at all phases of the customer journey to optimize, accelerate, and achieve business outcomes. Our ...
-
Data Engineer
1 week ago
NTT DATA Group Corporation Michigan Center, United StatesAt NTT DATA, we know that with the right people on board, anything is possible. The quality, integrity, and commitment of our employees have been key factors in our company's growth and market presence. By hiring the best people and helping them grow both professionally and perso ...
-
Skilled Maintenance Technician
1 week ago
Toyota Kentucky Jonesville, United States Full timeOverview · Who we are · Collaborative. Respectful. A place to dream and do. These are just a few words that describe what life is like at Toyota. As one of the world's most admired brands, Toyota is growing and leading the future of mobility through innovative, high-quality solut ...
-
Toyota Kentucky Jonesville, United States Full timeOverview · Who we are · Collaborative. Respectful. A place to dream and do. These are just a few words that describe what life is like at Toyota. As one of the world's most admired brands, Toyota is growing and leading the future of mobility through innovative, high-quality solut ...
-
Salary Accountant
1 week ago
Infinity Systems Lake LeAnn, United StatesAbout the Company · Our auditing and tax consulting firm in Wuppertal is a medium-sized consulting company on a growth path, and has been part of the ETL Group since 2017. With our approximately 170 employees, we offer our diverse clients high-quality solutions in the areas of bu ...
-
Dynamics 365 developer
4 days ago
Ageatia Global Solutions Michigan Center, United StatesWe are seeking an experienced Dynamics 365 developer for our Software as a Service team. This team is responsible for providing Dynamics 365, PowerApps, and SharePoint solutions to meet the business needs of our MDHHS partners. As a Dynamics 365 developer, they will be expected t ...
-
Front Desk Manager
6 days ago
Davenport University Michigan Center, United StatesAt Davenport University, we know what it takes to be successful. With over 150 years of providing quality education under our belts, thousands of Davenport graduates are making an impact on the world with the knowledge and skills they learned here. Our team of faculty and staff c ...
-
Peoplesoft developer
1 week ago
Diverse Lynx Michigan Center, United StatesJob Title Peoplesoft developer Relevant Experience · (in Yrs) 6+ Technical/Functional SkillsTechnical: PeopleSoft Internet Architecture · Application Designer, PeopleTools, PeopleCode · PS Query · Process Knowledge - Benefits Administration, Core HR, Workforce Administration, Rec ...
-
Snowflake Developer
3 days ago
FIS Michigan Center, United StatesJob Description · We are FIS. Our technology powers the world's economy and our teams bring innovation to life. We champion diversity to deliver the best products and solutions for our colleagues, clients and communities. If you're ready to start learning, growing and making an ...
-
Data Engineer
1 day ago
Ndimensions IT Jackson, United StatesJob Description · Job DescriptionDuration : 6 Months · Location : Mostly Remote ( Some Travel when required) · We are seeking a skilled Data Engineer to join our team. The ideal candidate will be responsible for designing, implementing, and maintaining data pipelines in Alteryx A ...
-
Communications Specialist
2 weeks ago
Planet Interactive Jackson, United StatesCommunications Specialist · Planet Interactive is in search of a Communications Specialist to join one of the top utility companies in the US. This is a hybrid role, onsite twice a week in Jackson, MI. · Pay Rate: Up to $40/hr depending on experience · Communications Specialist R ...
-
Power Suite Process Automation Specialist
2 days ago
iMPact Business Group Jackson, United StatesJob Description · Our Client, a Public Utility that provides natural gas and electricity to the majority of Michigan's 10 million residents is seeking a talented and self-driven individual for needs serving in the role of Power Suite Process Automation Specialist · DUTIES: · ...
-
Sr Indirect Tax Analyst
1 week ago
Consumers Energy Jackson, United StatesJoin the diverse and dynamic team that powers Michigan's largest energy provider and one of the nation's largest gas and electric combination utilities. Consumers Energy services 6.8 million of Michigan's 10 million residents - caring for our friends and neighbors in all 68 Lower ...
-
Financial Grants Manager
1 week ago
Community Action Agency Jackson, United StatesJob DetailsLevelExperiencedJob LocationJackson Office - Jackson, MIPosition TypeFull TimeEducation Level4 Year DegreeSalary Range$55, $72,862.00 Salary/yearTravel PercentageNegligibleJob ShiftDayJob CategoryFinanceDescriptionPosition Overview: Requests advances/reimbursements fro ...
-
Financial Grants Manager
1 week ago
Community Action Agency Jackson, United StatesJob DetailsLevelExperiencedJob LocationJackson Office - Jackson, MIPosition TypeFull TimeEducation Level4 Year DegreeSalary Range$55, $72,862.00 Salary/yearTravel PercentageNegligibleJob ShiftDayJob CategoryFinanceDescriptionPosition Overview: Manages cash for the Agency. Request ...
-
Sr Indirect Tax Analyst
1 week ago
Consumers Energy Jackson, United StatesJoin the diverse and dynamic team that powers Michigan's largest energy provider and one of the nation's largest gas and electric combination utilities. Consumers Energy services 6.8 million of Michigan's 10 million residents - caring for our friends and neighbors in all 68 Lower ...
-
Financial Grants Manager
2 days ago
Community Action Agency Jackson, United StatesJob Details · Level · Experienced · Job Location · Jackson Office - Jackson, MI · Position Type · Full Time · Education Level · 4 Year Degree · Salary Range · $55, $72,862.00 Salary/year · Travel Percentage · Negligible · Job Shift · Day · Job Category · Finance · ...
ETL/BI Developer - Michigan Center, United States - Indus Valley
Description
Title:
ETL/BI Developer
Location:
Lansing, MI (Hybrid - 2 days onsite and 3 days remote)
Duration:
Long Term
JOB DESCRIPTION:
Top Skills & Years of Experience:
FULL JOB DESCRIPTION:
The position functions as a senior information technology analyst responsible for developing, maintaining, and enhancing a variety of automated data warehouse applications located on the State of Michigan's Teradata Data Warehouse platform.
In addition, the position will work with other data warehouse developers to review existing data warehouse policies and practices, modify them as needed, or propose new policies or practices.
This position is part of the Michigan Department of Health and Human Services (DHHS) Data Warehouse Team.Knowledge of SQL, Business Intelligence tools, and experience with the relational database is required to help develop and maintain DHHS data warehouse ETL and queries.
CANDIDATES WILL BE EVALUATED ON THE FOLLOWING CRITERIA:
REQUIRED SKILLS:
ADDITIONAL SKILLS:
o Captures requirements of data elements
o Designs data elements to best meet application needs
o Reviews and approves updates to systems documentation.
