25 days old
2018-05-232018-06-20

Data Analyst

Kansas City, MO 64105
  • Job Code
    622852

Job Duties:



  • 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 environment
  • 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.
  • 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 development team.
  • 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 well designed 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 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.


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 steps
  • Familiar 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.

Categories

Featured Jobs

Career News

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Analyst

Randstad Technologies
Kansas City, MO 64105

Share this job

Data Analyst

Randstad Technologies
Kansas City, MO
US

Separate email addresses with commas

Enter valid email address for sender.

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast