Published: November 7, 2019
Location
Cincinnati,, Ohio
Job Type

Description

SQL Developer-learn SAP

The SQL Developer will be a full time, permanent employee at our industry leading client. Our client is headquartered in Cincinnati. They are growing rapidly and expanding into new areas. They are looking for someone who understands the value of team and wants to build a career with a great company and team. Full benefits including paid vacation, holidays, medical, dental, 401k etc.

As a member of the Business Intelligence team, the SQL Developer is responsible for managing the design, development, implementation, management and support of enterprise Business Intelligence reporting processes. Our client is implementing SAP and this person will have the chance to be trained on SAP’s latest business intelligence tools.

The SQL Developer will be required to lead the designing phase of solutions to develop ETL solutions with various products including SSIS, T-SQL, and other tools.

General Responsibilities:

Create SSIS packages to process data to the data warehouse and other data marts
Develop standards for naming, describing, storing, searching and delivering data for business intelligence applications
Perform complex data analysis/validation to ensure the accuracy and integrity of data
Troubleshoot and research data anomalies and recommend/implement corrective actions
Perform performance optimization and tuning on new and/or existing data warehouse and/or ETL operations
Provide application enhancement and upgrade support, including any re-engineering due to changes of file and table structure of source systems
Support internal customers in investigation of data issues
Collaborate with Database Administrator and Solutions Architect to determine strategy for data warehouse design architecture and the backup/recovery
Participates in all phases of the SDLC to ensure and verify that the design meets defined business requirements
Ensures adherence to data management/data governance policies
Participate in process flow analysis and process redesign with IT and business
Create and maintain of documentation for existing architecture, data dictionaries, future data warehouse architecture and business intelligence reporting
Prepare accurate and detailed requirement specifications documents, work flow analysis, user guides, and functional specification documents
Assist in the creation of new reports based on business requirements

Experience and Education Requirements:

Bachelor's degree in Computer Science or related field preferred
5+ years related experience as a SQL Developer/Data Analyst or similar position
Knowledge of data governance, data management, data modeling, data cleansing, data extraction and transformation, data analysis, data migration, data integration and data mapping
2+ years SQL Server Integration Services (SSIS) for ETL and SQL Server Reporting Services (SSRS) for report generation
Proficient in writing complex T-SQL Stored Procedures and functions
Experience in database design and management such as Oracle, SQL, and/or DB2
Experience with SAP Analytics Cloud a plus
Experience working with SAP HANA a plus
Experience with Lean Six Sigma and Project Methodologies (Agile, Waterfall, or etc.)
Excellent analytical and problem solving skills
Strong planning and organizational skills

View our nationwide job openings and sign up for alerts at: https://www.technologyrecruiting.com/non-it-jobs/

Apply
Drop files here browse files ...

Related Jobs

Salesforce Systems Developer   Philadelphia, PA new
October 31, 2019
Full Stack Developer   Houston, Texas new
October 29, 2019
Sharepoint Developer   Houston, Texas new
October 29, 2019
October 29, 2019
Oracle APEX Applications Developer   Little Rock, Arkansas
May 6, 2019