Job Information

G-TECH Services, Inc. Data Warehouse & ODI Developer in Farmington Hills, Michigan

Position Summary

Provides and/or facilitates the planning, analysis, design, development, implementation, and maintenance of software, scripts, and utilities that support timely and accurate data population of Amerisure’s Enterprise Data Warehouse (EDW).


  • Provide technical Data Warehouse and ETL expertise necessary to meet project and business requirements as well as production and maintenance in support of assigned project and application areas.

  • Work with other EDW Development team members to estimate, plan, and schedule tasks to meet assigned target dates.

  • Participate in the requirements gathering, preparation of specifications, and design for new projects and/or existing systems.

  • Build use cases and execute test plans that encompass unit testing and analysis of results.

  • Document new and existing systems, develop workflows, and create other supporting documents in adherence to all departmental and corporate standards, provide a clear audit trail of activities taken on specific projects.

  • Obtain approvals and consult with Production Control as needed to prepare programs and systems for implementation.

  • Review completed code, documentation and other deliverables to ensure that they meet specifications and requirements based on defined expectations.


  • Bachelor's degree in Business, Computer Science, or Engineering required or equivalent work-related experience.

  • Three years' experience working in an Oracle data warehouse environment using ETL tools including PL/SQL and Oracle Data Integrator (ODI).

  • Demonstrates experience and knowledge of data structure and database concepts and practices, with ability to monitor and tune performance.

  • Proficient understanding of multiple data warehouse/BI related technologies, including DBMS, dimensional warehouses, scripting, reporting tools, and Oracle SQL tuning.

  • Ability to interpret conceptual, logical, and physical ER modelling and dimensional data models.

  • Excellent verbal and written communication skills with the ability to lead collaborative project discussions and present technical solutions to a diverse array of business customers.

  • Demonstrates experience in one or more systems development life cycle (SDLC) methodologies, including those that support agile/iterative development.

  • Demonstrates knowledge of project management methodologies.

  • Demonstrated successful ability to build positive relationships and partnerships within department, across the organization, and with external customers.

  • Ability to think strategically with supporting analytical and problem-solving skills, including the ability to deal with ambiguity.

  • Insurance industry experience strongly preferred.

Category Database Administration

Function Information Technology

Req ID JN -052019-111343

Have any questions? We can help. Contact Us

facebooklinkedinConnect with us on social media.