- the design of the logical data model and implements the physical database structure and constructs and implements operational data stores and data marts
- and support stored procedures, understand and code in open SQL language in SQL and HANA cloud foundry (BAS) environments
- smart data Integration (SDI) objects between multiple source systems which helps in transformation, extraction and loading into target database
- logical and physical data flow models for ETL
- complex data analysis/validation to ensure the accuracy and integrity of data
- and research data anomalies and recommend/implement corrective actions
- performance optimization and tuning on new and/or existing data warehouse and/or ETL operations
- in ongoing architecture quality review activities to ensure both current and future capability meets architecture standards
- and maintain of documentation for existing architecture, data dictionaries, future data warehouse architecture and business intelligence reporting
- accurate and detailed requirement specifications documents, workflow analysis, user guides, and functional specification documents
- storage needs for reporting databases and data warehouse
-
ETL Developer
2 weeks ago
Qual IT Resources Cincinnati, United StatesETL Developer · 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 ...
-
ETL Developer
18 hours ago
CBTS Cincinnati, United StatesCBTS 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 ...
-
ETL Developer
1 day ago
Planet Technology Cincinnati, United StatesPlanet 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 ...
-
ETL Developer
1 week ago
Encore Talent Solutions Cincinnati, United StatesEncore Talent is seeking an ETL Developer to be 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 warehousi ...
-
ETL- DEVELOPER
2 weeks ago
Shiftcodeanalytics Cincinnati, United StatesExcellent 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 ...
-
ETL Developer
18 hours ago
Planet Technology Cincinnati, United StatesBusiness 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 ...
-
ETL Developer
2 weeks ago
Qual IT Resources Cincinnati, United StatesETL Developer · 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 u ...
-
ETL Developer
5 days ago
Insight Global Cincinnati, United StatesA 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 ...
-
ETL Developer
1 week ago
CBTS Cincinnati, United StatesCBTS 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 Int ...
-
ETL Developer
5 days ago
CBTS Cincinnati, United StatesCBTS 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 ...
-
ETL Developer
1 day ago
Insight Global Cincinnati, United StatesA 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 ...
-
ETL Developer
2 weeks ago
Planet Technology USA Cincinnati, United StatesBusiness 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 enterpri ...
-
ETL Developer
2 weeks ago
Planet Technology USA Cincinnati, United StatesBusiness Intelligence/ETL Developer · Location - Cincinnati, OH - Hybrid - Prefer local candidates · All potential applicants are encouraged to scroll through and read the complete job description before applying. · As a member of the Business Intelligence team, the ETL Develo ...
-
ETL Developer
2 weeks ago
Encore Talent Solutions Cincinnati, United StatesEncore Talent is seeking an ETL Developer to be 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 warehousi ...
-
ETL Developer
4 days ago
CBTS Cincinnati, United StatesCBTS 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 ...
-
ETL Developer
4 days ago
Insight Global Cincinnati, United StatesA 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 ...
-
ETL Developer
2 weeks ago
Insight Global Cincinnati, United StatesJob Description · 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 suggestion ...
-
ETL Developer
2 days ago
CBTS Cincinnati, United StatesCBTS 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 ...
-
BI ETL Developer
4 days ago
Rumpke Cincinnati, United StatesAs 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 ...
-
Senior ETL Developer
1 day ago
Western & Southern Financial Group Cincinnati, United StatesWestern & 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 ...
ETL Developer - Cincinnati, United States - Qual IT Resources
Description
ETL Developer
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.
General Responsibilities:
Uses different data warehousing concepts to build a data warehouse for internal departments of the organization
Creates and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing, and analyzing large sets of data
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)
Experience and Education Requirements:
Bachelors degree in computer science or related field preferred
3+ years related experience as a ETL Developer/Data Analyst or similar position
3+ years related experience with data modeling with Cloud concepts (Snowflake, HANA calculation views)
Experience working with SAP HANA cloud foundry is a plus
Experience with SAP Analytics Cloud a plus
Strong understanding of SQL Server Integration Services (SSIS) (or similar tools) for ETL
Proficient in MS SQL Server (or similar relational databases like Oracle and PostgreSQL)
Experience in database design and management.
Non-Technical Requirements:
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
Able to multi-task in fast paced environment and manage time effectively
Passion for customer service, efficiency, effectiveness, precision, and quality
Good team player, and willingness to assist others, and share expertise
Able to work flexible hours; expected to work nights and weekends as needed
Ability to travel between offices, as required