Senior ETL/BI Developer Job at Cloud Analytics Technologies LLC, Lansing, MI

ZEpOZGVTUVY5MkpsTFlaNm0rSE5VZ0RVNWc9PQ==
  • Cloud Analytics Technologies LLC
  • Lansing, MI

Job Description

Summary

Required Skills:

  • 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 system.
  • Please note, manager wants to ensure the ideal candidate can work in a cross functional capacity between ETL and BI tasks. Those with experience in Snowflake and Databricks should be successful in this role.
  • 2+ Years Child Welfare Services, Juvenile Justice, Juvenile services, or other related experience
  • SQL Assistant/Teradata Studio Experience, BI applications

Additional Skills:

  • Experience with the State of Michigan PMM/SUITE/Agile methodology
  • SQL Assistant/Teradata Studio Experience, BI applications
  • End user training experience
  • Must be able to work independently with little directions
  • 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, and 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.
  • Ability 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.
  • Assist Architect or DBA to draft technical database model that:
    • Complies with audit separation of duty requirement.
    • Captures requirements of data elements
    • Designs data elements to best meet application needs
    • Reviews and approves updates to systems documentation.
  • Gather, review, and analyze potential impacts of changes and inform DTMB management and supported client agency 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.

Job Tags

Work at office, Immediate start

Similar Jobs

aisle_and_abroad

Remote Travel Specialist - Cruise & Resort Focus Job at aisle_and_abroad

 ...Remote Travel Specialist Cruise & Resort Focus Location: Remote (U.S.) About Us: We are a premier travel agency partnered with an award-winning host agency with over 70 years of experience. We specialize in crafting unforgettable getaways, offering cruises... 

MissionWired

Vice President, Digital (Nonprofit) Job at MissionWired

At MissionWired, we help nonprofit organizations and Democratic campaigns advance their revenue and cause. By unifying direct response programs from email, direct mail, and advertising to analytics, creative, and acquisition weve helped raise over $5 billion for our...

MASONICARE

RN Hospice Nurse - Weekend Baylor Job at MASONICARE

 ...RN Hospice Nurse - Weekend Baylor Masonicare Home Health & Hospice - Wallingford, CT area Part Time / Work 24hrs/wk / Paid 32hrs/wk **Flexible Weekend Scheduling** inquire within for options RN / REGISTERED NURSE The trusted healthcare resource chosen... 

Best Commercial Glass LLC

Call Center Representative Job at Best Commercial Glass LLC

 ...are looking for a motivated friendly and customer-oriented Call Center Representative to join our team. The successful candidate will handle incoming...  ...skills basic computer knowledge and the ability to work professionally in a fast-paced environment. Previous customer... 

IDS International

Visitor Security Control Specialist Job at IDS International

 ...Job Title Visitor Security Control Specialist Why IDS? IDS believes in resolving conflict, building innovative approaches to do so. Combining...  ...Control Specialist to support visitor access control and physical security operations. The selected candidate will assist...