Home > Cincinnati jobs > Cincinnati computer/technical

Posted: Tuesday, February 6, 2018 6:00 PM

Do you want to work for a great company, with plenty of opportunity to grow, and a positive team environment?
Data Solutions Analyst
Purpose: Support the Enterprise by performing data management, programming, analytic and consultative activities including database, documentation and data trending assessment. Design, develop, and update data integration, profiling, and cleansing routines. Ensure all relevant metadata is captured and/or updated. Provide related modeling, mapping, and process assistance.
Essential Duties:
Design, develop, test, and update data integration (ETL, replication, change data capture), data profiling, and data profiling processes.
Update and maintain metadata repositories and dictionaries.
Responsible for creating, validating, and/or updating source:to:target maps. Help perform source analysis and supports departmental process improvement initiatives.
Assist with logical and physical model design, source:to:target mapping, use cases, and other development processes and artifacts.
Identify data subject areas, entities, attributes, relationships, information types, and domains. With project team, design and communicate logical and/or physical models and designs.
Responsible for supporting identification of physical implementation requirements, including normalization techniques and referential integrity or dimensional techniques.
Assist with defining, maintaining, and enforcing data architecture, definitions, and standards. Participate in data policy, standards, and procedure development processes. Perform code reviews, data model reviews, and testing.
Establish standards and best practices.
Work with IT partners to perform periodic system and database operational tests, audits, and tuning. Responsible for promoting understanding of data quality concepts and methods. Identify, document, and recommend solutions for poor quality data.
5:8 years of related experience.
Intermediate knowledge of database concepts, methodologies, and architectural approaches.
Extensive knowledge of database systems and administration, including security, development and testing support, modeling and logical design, database design, and qualify control.
Demonstrate strong quantitative, analytical, and problem solving skills, with ability to adapt to new methods, techniques, and procedures.
Intermediate knowledge of logical and physical data modeling and data modeling tools. Experienced in complex SQL statements, Microsoft Access, SQL databases, VB programming language, Excel, Data Warehousing, ETL and possibly Crystal Reports. Proficient in Microsoft Office products (Word, PowerPoint, and Project).
Knowledge of Business Objects and/or Crystal Reports preferred. Intermediate knowledge of ETL, replication, change data capture and other data integration techniques and technologies (Microsoft SQL Server 2008 Suite of tools (SQL Server Management Studio, SSIS, SSRS, SQL Server Business Intelligence Studio, etc).
Experience with Eclipse
Experience with Web Services
Ability to work effectively in a team environment.
Excellent verbal and written communication skills required.
Bachelor's Degree in MIS, Computer Science or related field required.


• Location: Cincinnati, portland

• Post ID: 58475772 cincinnati is an interactive computer service that enables access by multiple users and should not be treated as the publisher or speaker of any information provided by another information content provider. © 2018