BI ETL Developer

2 weeks ago

Cincinnati, United States Rumpke Full time

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 work flexible 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 60-1.35(c)

  • BI ETL Developer

    3 months ago

    Cincinnati, United States Rumpke of Ohio, Inc. Full time

    Job DescriptionJob 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 Developer will use their knowledge of data warehousing and architecture to develop...

  • BI ETL Developer

    3 months ago

    Cincinnati, United States Rumpke Full time

    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...

  • Power BI Engineer-W2

    3 months ago

    Cincinnati, United States eTek IT Services, Inc. Full time

    Job DescriptionJob DescriptionOverviewAs a Power BI Engineer-W2, you will play a pivotal role in developing and maintaining business intelligence solutions using Power BI. Your expertise will contribute to the transformation of raw data into actionable insights, driving strategic decision-making within the organization.Key responsibilitiesDesign and develop...

  • ETL- DEVELOPER

    2 months ago

    Cincinnati, United States ShiftCode Analytics Full time

    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 gather requirements and translate them into technical specifications. Perform...

  • ETL Developer

    2 weeks ago

    Cincinnati, United States AssureCare Full time

    Do you have experience building complex enterprise wide software solutions? Are you interested in joining a fast- growing software company delivering enterprise medical management solutions that empower our customers to provide member focused care? AssureCare is looking for motivated, team-oriented individuals to join an ambitious software company making a...

  • ETL Solutions Architect

    1 week ago

    Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a skilled Informatica Developer with extensive experience in ETL processes and data integration solutions. The ideal candidate will possess a strong background in SQL and Unix Shell, along with proficiency in Informatica PowerCenter. Key...

  • ETL Solutions Architect

    1 week ago

    Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a skilled Informatica Developer with extensive experience in ETL processes and data integration. The ideal candidate will possess a strong background in database programming and will be responsible for the design, development, and...

  • ETL Solutions Architect

    2 weeks ago

    Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a skilled Informatica Developer to join our team at Diverse Lynx. The ideal candidate will possess extensive experience in ETL development and data integration processes.Key Responsibilities:Over 7 years of experience in delivering robust...

  • ETL Solutions Architect

    1 week ago

    Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a proficient Informatica Developer with extensive experience in ETL processes and data integration. The ideal candidate will possess a strong background in database programming and data warehousing solutions.Technical Skills...

  • ETL Solutions Architect

    1 week ago

    Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:We are seeking a skilled Informatica Developer with extensive experience in ETL processes and data integration. The ideal candidate will possess a strong background in SQL and Unix Shell, alongside proficiency in Informatica PowerCenter.Key Skills:Languages:...

  • ETL Solutions Architect

    2 weeks ago

    Cincinnati, Ohio, United States Diverse Lynx Full time

    Job Title: Informatica DeveloperLocation: Cincinnati, OH-OnsiteDuration: Full Time-Only Job Overview:As an Informatica Developer, you will play a crucial role in the design and implementation of ETL processes that support our data warehousing initiatives. Your expertise will contribute to the seamless integration of diverse data sources, ensuring...

  • Jr. Sql

    2 weeks ago

    Cincinnati, United States Vaco Full time

    Vaco is hiring multiple BI Developers for full time roles located onsite in Northern Kentucky and downtown Cincinnati. The BI Developers are are fully onsite (5 days a week) and local candidates are encouraged to apply. These opportunities offer room for career growth and advancement. These are a great steppingstone in your technical career. At least 1-2...

  • Jr. Sql

    2 weeks ago

    Cincinnati, United States Vaco Full time

    Vaco is hiring multiple BI Developers for full time roles located onsite in Northern Kentucky and downtown Cincinnati.The BI Developers are are fully onsite (5 days a week) and local candidates are encouraged to apply.These opportunities offer room for career growth and advancement. These are a great steppingstone in your technical career. At least 1-2 years...

  • Jr. Sql

    1 week ago

    cincinnati, United States Vaco Full time

    Vaco is hiring multiple BI Developers for full time roles located onsite in Northern Kentucky and downtown Cincinnati.The BI Developers are are fully onsite (5 days a week) and local candidates are encouraged to apply.These opportunities offer room for career growth and advancement. These are a great steppingstone in your technical career. At least 1-2 years...

  • Jr. Sql

    3 weeks ago

    Cincinnati, United States Vaco Full time

    Vaco is hiring multiple BI Developers for full time roles located onsite in Northern Kentucky and downtown Cincinnati.The BI Developers are are fully onsite (5 days a week) and local candidates are encouraged to apply.These opportunities offer room for career growth and advancement. These are a great steppingstone in your technical career. At least 1-2 years...

  • Jr. Sql

    2 weeks ago

    Cincinnati, United States Virtual Full time

    Vaco is hiring multiple BI Developers for full time roles located onsite in Northern Kentucky and downtown Cincinnati. Please note, these roles are fully onsite (5 days a week) and local candidates are encouraged to apply. These opportunities offer room for career growth and advancement. These are a great steppingstone in your technical career. At least 1-2...

  • Jr. Sql

    2 weeks ago

    Cincinnati, United States Vaco Full time

    Vaco is hiring multiple BI Developers for full time roles located onsite in Northern Kentucky and downtown Cincinnati. Please note, these roles are fully onsite (5 days a week) and local candidates are encouraged to apply. These opportunities offer room for career growth and advancement. These are a great steppingstone in your technical career. At least 1-2...

  • Jr. Sql

    23 hours ago

    Cincinnati, United States Vaco Full time

    Vaco is hiring multiple BI Developers for full time roles located onsite in Northern Kentucky and downtown Cincinnati. Please note, these roles are fully onsite (5 days a week) and local candidates are encouraged to apply. These opportunities offer room for career growth and advancement. These are a great steppingstone in your technical career. At least...

  • Informatica Developer

    4 weeks ago

    Cincinnati, United States Diverse Lynx Full time

    Job Title: Informatica Developer Location: Cincinnati, OH-Onsite Duration: Full Time-Only Job Description: Languages: SQL, Unix Shell Tools: Informatica PowerCenter Databases: Oracle, SQL Server, and Teradata. Big Data: Cloudera Hadoop, Hive Dev Methodologies: Agile, Waterfall Others: Toad, SVN, Control-M, Dollar Universe or Autosys - 7+ years of...

  • BI Consultant

    3 months ago

    Cincinnati, United States AMEND Consulting Full time

    Description Position at AMEND Consulting About AMEND: AMEND is a management consulting firm based in Cincinnati, OH with areas of focus in operations, analytics, and technology, focused on strengthening the people, processes, and systems in organizations to generate a holistic transformation. Our three-tiered approach provides a distinct competitive edge...