Summary

Position is located in Kansas City, MO area but eligible for relocation for non-local candidates.

Leads highly complex or enterprise critical projects that architects an efficient way to manage data across a diverse but unified data tier. Design, translate business requirements, develop, document, test, monitor, troubleshoot and administrate our data environment using our ETL, Data Virtualization, Business Intelligence Reporting, and Big Data tool sets

Duties and Responsibilities

• Ability to help design, build and manage data pipelines for data structures encompassing data transformation mapping, data flow diagrams, logical and physical data models, and metadata collection. The ability to work with both IT and business in developing, managing, and integrating business intelligence reporting, analytics, and data science output into business processes and workflows.
• Helps develop data strategies and translates them into data integration frameworks and reporting to enable business analytics
• Provide a standard common business vocabulary, express strategic data requirements, outline high level integrated designs to meet these requirements, and align with enterprise strategy and related business architectures.
• Leads planning sessions with customers to improve business processes and prioritize investments in data and infrastructure.Works closely with Technical Review Board and Enterprise Architects to assure all systems are in line with the long-term IT strategy.
• Proactively analyzes existing data structures or reporting to identify weaknesses and develop opportunities for improvements.May oversee or lead the evaluation and selection process for new data application packages.
• Develop and document IT data models (Conceptual, Logical and Physical) to facilitate efficient and effective use of data
• Implement and maintain solutions for modeling, ETL/API, data mining, and metadata management
• Develops decision matrix on when to use various data platforms (data warehouse, data mart, big data, or data virtualization)
• Leads and oversees effort to identify data requirements, develops data specifications, enforces data governance, applies data modeling patterns, develops data conversion and migration designs, and develops convergence plans toward data standards.
• Assist with developing and executing best practices for naming, governing, managing, modeling, cleansing, transforming, moving, storing, and searching all data. Ensure changes to the data environment are compliant to the architectural standards.
• Actively participate in design and data model reviews providing constructive feedback to Application Developers
• Manages multiple priorities of projects and requests.
• Proposes appropriate changes to the enterprise data architecture to keep pace with Business and Market developments
• Adheres to data quality standards and data procedures. Reviews data models for data quality assurance and validates compliance with data architecture standards.
• Defines development guidelines and standards for data management on structured and unstructured data sets
• Demonstrates project management skills and may serve as a lead on IT projects.
• Manages and provides Tier III support for reporting, data structures, and related data applications.
• Provides technical guidance, business process expertise and technical leadership to team members.
• Establishes liaison relationships with business partners and/or suppliers in order to provide technical solutions to meet user needs and influence strategic initiatives.

You Must Have

• Bachelors +5 years of experience
• Certification + 5 years
• 7 years if no Bachelor or Certification
• US Citizenship, capable of obtaining and maintaining a US Dept of Energy "Q" level security clearance.

We Value

• Any experience with ETL and business intelligence tools.
• Any experience with Apache Hadoop environment.
• Knowledge of at least one data modeling software tool such as Erwin, ER/Studio, or Power Designer.