ETL Developer

Direct Hire/No (Sponsorship, C2C, OPT, F1)/Hybrid 3 Days a week/Fairfield, OH/$115K - $125K

3 weeks PTO, 6 paid holidays, Health/Dental Insurance and 401K - 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 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:

• different data warehousing concepts to build a data warehouse for internal departments of the organization
• and enhances data solutions enabling seamless delivery of data and is responsible for collecting, parsing, managing, and analyzing large sets of data
• 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 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)
• 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

Experience and Education Requirements:

• degree in computer science or related field preferred
• years related experience as a ETL Developer/Data Analyst or similar position
• years related experience with data modeling with Cloud concepts (Snowflake, HANA calculation views)
• working with SAP HANA cloud foundry is a plus
• with SAP Analytics Cloud a plus
• understanding of SQL Server Integration Services (SSIS) (or similar tools) for ETL
• in MS SQL Server (or similar relational databases like Oracle and PostgreSQL)
• in database design and management.

Non-Technical Requirements:

• analytical and problem solving skills
• planning and organizational skills
• to clearly articulate pros and cons of various technologies and platforms
• interpersonal, verbal, and written communication skills
• to perform detailed analysis of business problems and technical environments and use this in designing the solution
• patience with other associates
• to estimate the financial impact of individual solution architecture alternatives
• to provide accurate estimates for tasks and project activity
• personal drive and initiative regarding career growth
• to work independently, prioritize own tasks, and tasks of others
• to multi-task in fast paced environment and manage time effectively
• for customer service, efficiency, effectiveness, precision and quality
• team player, and willingness to assist others, and share expertise
• to work flexible hours; expected to work nights and weekends as needed
• to travel between offices, as required

Cincinnati Bell Technology Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a protected veteran in accordance with applicable federal, state and local laws.