Previous Job
Previous
Data Analyst
Ref No.: 18-07688
Location: Kansas City, Missouri
Position Type:Contract
Start Date: 02/05/2018
Genesis10 is seeking a Data Analyst. This is a 12-month, extendable, contract opportunity with our Transportation industry client in Kansas City, Missouri.
 
Description:
The DA will be responsible for researching, analyzing and translating business requirements into technical data design and data model.  The ideal Data Analyst candidate will be a self-directed individual capable of assuming ownership in executing Business requirements, leading team activity, managing customer expectations and focused on delivering the right results at agreed upon timelines. Technical aptitude, programming skills, effective oral and written communication skills, and the ability to present insights in a clear concise and effective manner are critical and necessary in this role.  Experience with data science initiatives requiring machine learning, streaming analytics, predictive and prescriptive enterprise analytics are highly preferred.

Responsibilities:
  • Work with project teams and business stewards to refine business requirements that produce well-designed and developed solutions.
  • Function as the lead for BI-SDLC projects. Collaborate and work closely with Business analyst, System and Cloud data architects, ETL Integration specialists and Power BI dashboard development team.
  • Design and develop data models using Erwin Data Modeler and apply best practices for optimum performance of the models.
  • Convert functional requirements into technical specifications. Perform data analysis, data mapping, functional testing, unit testing, and test case preparation using required tools based on project needs.
  • Document project specific processes and data flows, data dependencies, data definitions and relevant business rules.
  • Establish data dictionaries to support the buildout of a data governance infrastructure.
  • Design and develop DDL scripts, ad hoc queries and data models for high performance projects and deliverables. Understand and evaluate existing SQL scripts and Data Models. 
Requirements:
  • 5+ years of experience as a programmer, programmer/analyst, systems analyst, database analyst, database manager, or data warehouse specialist.
  • Experience with the Software Development Life Cycle and ETL Processes. Technical expertise regarding data mining, database design development, data modelling, data governance and unit testing.
  • Experience with warehouse data extraction/transformation and load tools, as well as metadata repository tools.
  • Ability to analyze, identify, extract, translate and transform business requirements into data requirements.
  • Advanced proficiency in relational Database concepts, Database design using star and snowflake schema along with ability to write and execute complex SQL queries and stored procedures.
  • Proficient in data transformation, consolidating data from multiple disparate sources, develop process workflows and wireframe sketches to help business design effective dashboard solutions.
  • Excellent communication and presentation skills and must possess exceptional ability to work well with individuals and teams at all levels, across all division's.
  • Knowledge of various database platforms (DB2, SAP,MS SQL Server) required and experience with one or more of the following, Power BI, Informatica, Azure Cloud, IoT, MuleSoft, AQT, ErWin Data Modeling.
  • Familiar with Windows operating system, shell scripting. Proficient with MS Office tools like PowerPoint, MS Project, Visio, Excel and Word. 
If you have the described qualifications and are interested in this exciting opportunity, please apply!
 
About Genesis10:
Genesis10 is a leading U.S. business and technology consulting firm with hundreds of clients needing proven talent and solutions to power their strategic initiatives.  If you are a high performing business or IT professional with solid, referenced experience, we want to meet you.  Genesis10 recruiters and delivery professionals are highly accomplished career advocates, who get to know you beyond your resume to position you with the opportunities that fit your skills, experience and aspirations.  We have benefit options to fit your needs and a support staff that works with you from placement throughout your engagement – project after project.   To learn more about Genesis10 and to view all our available career opportunities, please visit us at www.genesis10.com. 
“Genesis10 is an Equal Opportunity Employer, M/F/D/V”