This site uses cookies. To find out more, see our Cookies Policy

data Warehouse developer in Farmington Hills, MI at Interactive Business Systems

Date Posted: 10/12/2018

Job Snapshot

Job Description

    Interactive Business Systems is teaming up with a Farmington Hills company to locate and bring on a Data Warehouse Developer for a direct hire role!

    Summary Statement

    •        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 Client's Enterprise Data Warehouse (EDW).

    Essential Tasks/Major Duties

    •        Provide technical expertise necessary to meet project and business requirements as well as production and maintenance in support of assigned project/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 program or system projects.

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

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

    Knowledge, Skills & Abilities

    •        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/or 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/system 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.

Interested candidates should send a resume and brief cover note to the attention of Chris Douglas at Interactive Business Systems (

IBS offers a competitive salary and comprehensive benefits package to all employees. Referral and sign-on bonuses may also be available.

About IBS: IBS, Interactive Business Systems, Inc., is an IT solutions and staffing company known for achieving business objectives and bottom-line results through the smart architecting, implementation and management of technology. In three decades of developing the technology applications, tools, environments and teams that foster top business performance, we have become an industry-leading IT services provider.