Jobs
>
Cincinnati

    BI ETL Developer - Cincinnati, United States - Rumpke

    Default job background
    Description

    As a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowledge of data warehousing and architecture to develop ETL solutions and help automate data extraction from source systems and transform unstructured and disparate source data into target data stores or data marts.

    Responsibilities of Position:

    • Use different data warehousing concepts to build a data warehouse for internal departments of the organization, determine storage needs for reporting databases and data warehouse.
    • Create and enhance data solutions enabling seamless delivery of data; responsible for collecting, parsing, managing, performing complex data analysis/validation on large sets of data to ensure the accuracy and integrity of data and research/troubleshoot data anomalies to recommend/implement corrective actions.
    • Lead the design of the logical data model and implement the physical database structure and constructs and implements operational data stores and data marts.
    • Develop and support stored procedures, understand and code in open SQL language in SQL and HANA cloud foundry (BAS) environments.
    • Develop smart data Integration (SDI) objects between multiple source systems which helps in transformation, extraction and loading into target database.
    • Develop logical and physical data flow models for ETL applications.
    • Monitor, create and troubleshoot SAP job failures, through SAP HANA and SAC cockpit for high performance system availability (i.e. Alerts, services, disk space usage, memory usage, CPU usage, stored procedures for QA/DEV/PRD).
    • Perform performance optimization and tuning on new and/or existing data warehouse and/or ETL operations.
    • Participate in ongoing architecture quality review activities to ensure both current and future capability meets architecture standards.
    • Create and maintain documentation for existing architecture, data dictionaries, future data warehouse architecture and business intelligence reporting.
    • Prepare accurate and detailed requirement specifications documents, workflow analysis, user guides, and functional specification documents.
    • Other duties as assigned.
    Skills & Abilities Needed for Position:
    • Excellent analytical and problem solving skills.
    • Strong planning and organizational skills.
    • Ability to clearly articulate pros and cons of various technologies and platforms.
    • Outstanding interpersonal, verbal, and written communication skills.
    • Ability to perform detailed analysis of business problems and technical environments and use this in designing the solution.
    • Exhibit patience with other associates.
    • Ability to estimate the financial impact of individual solution architecture alternatives.
    • Ability to provide accurate estimates for tasks and project activity.
    • Possess personal drive and initiative regarding career growth.
    • Ability to work independently, prioritize own tasks, and tasks of others.
    Physical Requirements in a Regular workday:
    • Occasionally Stooping/kneeling/crouching/crawling, climbing and/or balancing.
    Additional Working Conditions/Aspects:
    • Ability to travel between offices, as required.
    • Ability to workflexible hours; overtime, weekends, and/or holidays.
    • Ability to work overtime, weekends and/or holidays.
    • Must be available for 24-hour emergency calls.
    • Legally eligible to work in the United States.
    • Valid driver's license (if applicable).
    • Must successfully complete pre-employment testing.
    • Must be able to read and speak the English language.
    This job description is intended to describe the general nature, complexity, and level of work to be performed by employees assigned to this position and is not to be construed as an exhaustive list of responsibilities, duties and/or skills required. It does not prescribe or restrict the work that may be assigned. Furthermore, this does not establish a contract for employment and is subject to change at the discretion of the company.

    Rumpke Waste and Recycling is committed to equality in all aspects of employment. It is Rumpke's policy to provide equal opportunities to all employees and potential employees without regard to race, color, religion, gender, sexual orientation, gender identity, national origin, age, protected veteran status or disability status.

    Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

    The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR c)

  • CBTS

    ETL Developer

    3 weeks ago


    CBTS Cincinnati, United States

    CBTS is currently seeking an ETL Developer for a position located in Cincinnati, OH · Responsibilities: · Software feature development, data inquiries, troubleshooting, data analysis, and data pipeline build out. Responsible for producing stable, scalable, high quality database f ...

  • Shiftcode Analytics, Inc

    ETL- DEVELOPER

    1 week ago


    Shiftcode Analytics, Inc Cincinnati, United States

    Excellent SSIS skills AND excellent communication. Thanks · Responsibilities: Design, develop, and implement ETL processes using SSIS to extract, transform, and load data from various sources into the data warehouse. · Collaborate with business stakeholders and data analysts to ...

  • Insight Global

    ETL Developer

    3 weeks ago


    Insight Global Cincinnati, United States

    A large financial services client is seeking an ETL Developer for a permanent opportunity onsite in downtown Cincinnati. This person day to day responsibilities will include: · - 80% of their day is development · - 20% mentorship, code-reviews, giving suggestions · This person ...

  • CBTS

    ETL Developer

    3 weeks ago


    CBTS Cincinnati, United States

    CBTS is currently seeking an ETL Developer for a position located in Cincinnati, OH · Responsibilities: · Software feature development, data inquiries, troubleshooting, data analysis, and data pipeline build out. Responsible for producing stable, scalable, high quality database f ...

  • Insight Global

    ETL Developer

    3 weeks ago


    Insight Global Cincinnati, United States

    A large financial services client is seeking an ETL Developer for a permanent opportunity onsite in downtown Cincinnati. This person day to day responsibilities will include: - 80% of their day is development - 20% mentorship, code-reviews, giving suggestions This person should b ...

  • Insight Global

    ETL Developer

    1 week ago


    Insight Global Cincinnati, United States

    A large financial services client is seeking an ETL Developer for a permanent opportunity onsite in downtown Cincinnati. This person day to day responsibilities will include: - 80% of their day is development - 20% mentorship, code-reviews, giving suggestions This person should b ...

  • Planet Technology

    ETL Developer

    3 weeks ago


    Planet Technology Cincinnati, United States

    Planet Technology has partnered with a Cincinnati company to an ETL Developer for a full time position. Candidates are required to be onsite in our Cincinnati client offices at least three days a week. · This is a full-time position and we will not accept any inquiries from Thir ...

  • Insight Global

    ETL Developer

    3 weeks ago


    Insight Global Cincinnati, United States

    A large financial services client is seeking an ETL Developer for a permanent opportunity onsite in downtown Cincinnati. This person day to day responsibilities will include: · 80% of their day is development · 20% mentorship, code-reviews, giving suggestions · ○ This person shou ...

  • CBTS

    ETL Developer

    3 weeks ago


    CBTS Cincinnati, United States

    CBTS is currently seeking an ETL Developer for a position located in Cincinnati, OH. · As a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Inte ...

  • ShiftCode Analytics

    ETL- DEVELOPER

    1 week ago


    ShiftCode Analytics Cincinnati, United States

    Excellent SSIS skills AND excellent communication. Thanks · Responsibilities:Design, develop, and implement ETL processes using SSIS to extract, transform, and load data from various sources into the data warehouse.Collaborate with business stakeholders and data analysts to gath ...

  • CBTS

    ETL Developer

    3 weeks ago


    CBTS Cincinnati, United States

    CBTS is currently seeking an ETL Developer for a position located in Cincinnati, OH. · Make sure to apply quickly in order to maximise your chances of being considered for an interview Read the complete job description below. · As a member of the Business Intelligence team, the ...

  • Planet Technology

    ETL Developer

    3 weeks ago


    Planet Technology Cincinnati, United States

    Business Intelligence/ETL Developer · Location - Cincinnati, OH - Hybrid - Prefer local candidates · As a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise ...

  • Rumpke

    BI ETL Developer

    3 weeks ago


    Rumpke Cincinnati, United States

    As a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL Developer will use their knowled ...

  • Rumpke of Ohio, Inc.

    BI ETL Developer

    2 weeks ago


    Rumpke of Ohio, Inc. Cincinnati, United States

    Job Description · Job DescriptionAs a member of the Business Intelligence team, the ETL Developer is responsible for managing the design, development, implementation, management and support of critical enterprise Business Intelligence reporting processes and environments. The ETL ...

  • Western & Southern Financial Group

    Senior ETL Developer

    3 weeks ago


    Western & Southern Financial Group Cincinnati, United States

    Western & Southern Financial Group (W&SFG) is a Fortune 500 Financial Services company with a long history of strength and stability. We provide life and health insurance, annuities, mutual funds, and investment management products and services for millions of people through our ...

  • Western & Southern Life

    Senior ETL Developer

    3 weeks ago


    Western & Southern Life Cincinnati, United States

    Western & Southern Financial Group (W&SFG) is a Fortune 500 Financial Services company with a long history of strength and stability. We provide life and health insurance, annuities, mutual funds, and investment management products and services for millions of people through our ...


  • TEKsystems Cincinnati, United States

    Top Skills' Details · Must be ok with working onsite · DataStage Developer · ETL Developer/Snowflake · Description: · doing a major digital transformation, where they are moving all of their core banking systems to a new third party platform. This project will sit within Deposits ...

  • ShiftCode Analytics

    ETL Developer

    3 weeks ago


    ShiftCode Analytics Erlanger, United States

    -Client Location - Erlanger, KY - need to be onsite-Duration - 6 months Contract to hire-Visa: USC/GC-Interview Process - 2 video interviewMust Have - · •Builds ETL processes that will map data from source systems to target systems utilizing SSIS in an automated manner. · •Respon ...

  • Diverse Lynx

    ETL Developer

    1 week ago


    Diverse Lynx Union, United States

    7+ years of development experience in delivering ETL/database/programming solution.- 5+ years of hands-on experience with /designing/development of informatica applications.- Read and translate logical data models and use ETL skills to load the physical layer, based on an underst ...

  • Insight Global

    ETL Developer

    5 days ago


    Insight Global Union, United States

    A large financial services client is seeking an ETL Developer for a permanent opportunity onsite in downtown Cincinnati. This person day to day responsibilities will include:-80% of their day is development-20% mentorship, code-reviews, giving suggestions This person should be ab ...