Data Analyst in Kansas City, MO at GDH

Date Posted: 5/8/2018

Job Snapshot

Job Description

Position Summary:
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 focusedon delivering the right results at agreed upon timelines.The DA will be responsible for researching, analyzing and translating business requirements intotechnical data design and data model.Experience with data science initiatives requiring machine learning, streaming analytics, predictive andprescriptive enterprise analytics highly preferable.Technical aptitude, programming skills, effective oral and written communication skills, and the abilityto present insights in a clear concise and effective manner are critical and necessary in this role.
Knowledge & Skills:
Ability to be detail-oriented, self-motivated, and an excellent, creative problem-solver, with proven ability to successfully manage multiple disparate streams of work in a challenging, dynamic environmentExperience with the Software Development Life Cycle and ETL Processes. Technical expertise regarding data mining, database design development, data modelling, data governance and unit testing.Ability to 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 developmentteam.Ability to analyze, identify, extract, translate and transform business requirements into data requirements.Demonstrate solid organizational and perform detailed tasks with high degree of accuracy and perform under pressure. Must be able to multitask, prioritize and manage time effectively.Work with project teams and business stewards to refine business requirements that produce welldesigned and developed solutions.Proficient in data transformation, consolidating data from multiple disparate sources, develop process workflows and wireframe sketches to help business design effective dashboard solutions.Design and develop data models using Erwin Data Modeler and apply best practices for optimum performance of the models.Excellent communication and presentation skills and must possess exceptional ability to work well with individuals and teams at all levels, across all division’s.Must have ability to work in a structured environment as well as performing in high-pressure ad hoc mode to address urgent needsDocument 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.

Requirements:
Master’s or Bachelor’s degree in Computer Science, Data Science, MIS, Mathematics or related area and Demonstrated analytical and computer proficiency necessary through a combination of work and class work. 5+ years of experience as a programmer, programmer/analyst, systems analyst, database analyst, database manager, or data warehouse specialist.Experience with warehouse data extraction/transformation and load tools, as well as metadata repository tools.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.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.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.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.Demonstrate ability to communicate technical recommendations to a non technical audience in a clear and concise manner.Demonstrate ability to understand logical relationships and to ensure that programming faithfully replicates these relationships.Demonstrated ability to test and validate programming stepsFamiliar with Windows operating system, shell scripting. Proficient with MS Office tools like PowerPoint, MS Project, Visio, Excel and Word.Must demonstrate strong written and oral communication skills.
Preferred:
3+ years of hands-on experience with R, Python, MML, SAS Enterprise Miner or similar tools in support of on-demand, real-time analytic services.Ability to work with diverse set of data sources, such as Streaming Data, Time series data, semistructured and unstructured data.Ability to apply and develop appropriate statistical, machine learning, and/or deep learning models and algorithms to classify structured or unstructured data.