HireFT
Browse JobsHow it worksPricingAboutSuccess Stories
    Back to jobs
    US

    Usm

    Information Technology

    Data Modeler/Analyst - ONLY EAD or GC or USC

    Columbus, United StatesOn-SiteFull-timePosted 3w ago
    All Usm jobs

    Job description

    Data Modeler/Analyst - ONLY EAD or GC or USC

    Duration- $18months
    COlumbus OH

    Top Three Skills:
    1. Data profiling
    2. Source to target Mappings
    3. Data Modeling- Logical, Physical, Conceptual
    4. Data visualization
    5. SQL experience is also very important- We will be trying to use a tool called Informatica Data Quality to conduct data profiling. If for some reason we run into issues using this tool, we fall back to SQL.
    6. LEADERSHIP and COMMUNICATION- This position is viewed as a Director-level role in the organization. Candidates need to be able to effectively and confidently describe and execute on Data Analysis/Modeling strategies for the program.
    Job Description: A Lead data analyst performs a variety of tasks related to collecting, organizing and interpreting data. A data analyst will be responsible for inspecting, cleansing, transforming and modeling data. A data analyst wll have to deal with uncertainty about data information completeness and quality. A data analyst will play a dominant role in business intelligence, advanced analytics, data integration and master data management efforts and will be involved with traditional application development projects where necessary. Role accountabilities
    A data analyst will have a natural inclination and passion toward problem solving in a disciplined process oriented fashion. A data analyst will
    – Critically evaluates information gathered from multiple sources, reconciles conflicts, classifies the information in logical categories
    – Uses different visualization techniques and present the results of data exploration exercises
    – Understands the flow of data, business processes/technical interfaces that would be created or impacted
    – Documents the source to target mappings for both data integration as well as web services (consumer/provider mappings) that can be easily understood by the project team members with data quality and transformation rules
    – Identifies and documents sources of existing data as well as the new data. Understands use of master and reference data including sources and contributors.
    – Collaborates with data scientists and business partners and conducts data profiling and predictive analysis using a variety of standard tools
    – Creates conceptual, logical and physical data models and determines the most appropriate method to represent the data for business consumption. This includes all forms of physical representation of data, such as relational, dimensional, object, key-value (such as column families), and graph. Please note this list is not all inclusive.
    – Have joint accountability with data stewards and data architects on the projects to ensure conformance to enterprise data governance policies around information risk and data protection guidelines. Data analysts should be familiar with common policies around data masking and protection schemes.
    Recommended experiences
    Data source identification, data profiling, interpretation of patterns and trends, assessment of and improvement of data quality, versatility with visualization tools and techniques to share analysis findings. It is beneficial for individuals to have worked as a data analyst in any of the following types of projects:
    Analytically Intensive – Intended to draw/develop insights from data that is collected
    Operationally Data Intensive – Intended to create authoritative data sources that are essential to core transactional processing
    Data Integration Intensive – Requires the merging of many data types to satisfy business requirements

    Navya

    navyar@usmsystems(dot)com

    703-953-1819

    If my requirement matches your resume, then please do reply on my email id navyar(at)usmsystems(dot)com and contact no is 703-953-1819.

    Job details are sourced from the employer's original posting.

    Open job posting
    US

    About the company

    Usm

    Supports the maintenance and development of the extract transform and load (ETL) aspects of the data warehouse.

    View all Usm jobs
    Industry
    Information Technology
    Open roles
    1486

    Interested in this role?

    Apply with HireFT

    Free to start — no card required.

    Your fit

    How well do you match?

    Sign in to see how your résumé lines up with this role.