Sr Data Modeling Architect

$100,000 - $100,000/Yr

Honeywell International - Kansas City, MO

posted 3 months ago

Full-time - Mid Level
Kansas City, MO
Computer and Electronic Product Manufacturing

About the position

As a Senior Data Modeling Architect at Honeywell, you will lead highly complex and enterprise-critical projects that architect an efficient way to manage data across a diverse but unified data tier. Your role will involve designing, translating business requirements, developing, documenting, testing, monitoring, troubleshooting, and administrating our data environment using our ETL, Data Virtualization, Business Intelligence Reporting, and Big Data tool sets. You will be instrumental in helping to design, build, and manage data pipelines that encompass data transformation mapping, data flow diagrams, logical and physical data models, and metadata collection. You will work collaboratively with both IT and business teams to develop, manage, and integrate business intelligence reporting, analytics, and data science outputs into business processes and workflows. Your responsibilities will include developing data strategies and translating them into data integration frameworks and reporting to enable business analytics. You will 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. In this role, you will lead planning sessions with customers to improve business processes and prioritize investments in data and infrastructure. You will work closely with the Technical Review Board and Enterprise Architects to ensure all systems align with the long-term IT strategy. Proactively analyzing existing data structures or reporting to identify weaknesses and develop opportunities for improvements will be a key part of your responsibilities. You may also oversee or lead the evaluation and selection process for new data application packages. You will 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. Additionally, you will develop a decision matrix on when to use various data platforms (data warehouse, data mart, big data, or data virtualization) and lead efforts to identify data requirements, develop data specifications, enforce data governance, apply data modeling patterns, and develop data conversion and migration designs. Your role will also involve assisting with developing and executing best practices for naming, governing, managing, modeling, cleansing, transforming, moving, storing, and searching all data. You will ensure that changes to the data environment comply with architectural standards and actively participate in design and data model reviews, providing constructive feedback to Application Developers. Managing multiple priorities of projects and requests, proposing appropriate changes to the enterprise data architecture, and adhering to data quality standards will be essential aspects of your position. You will define development guidelines and standards for data management on structured and unstructured data sets, demonstrate project management skills, and may serve as a lead on IT projects. Furthermore, you will manage and provide Tier III support for reporting, data structures, and related data applications, providing technical guidance, business process expertise, and technical leadership to team members. Establishing liaison relationships with business partners and/or suppliers to provide technical solutions to meet user needs and influence strategic initiatives will also be part of your responsibilities.

Responsibilities

  • Lead highly complex or enterprise critical projects that architect an efficient way to manage data across a diverse but unified data tier.
  • Design, translate business requirements, develop, document, test, monitor, troubleshoot and administrate the data environment using ETL, Data Virtualization, Business Intelligence Reporting, and Big Data tool sets.
  • 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.
  • Work with both IT and business in developing, managing, and integrating business intelligence reporting, analytics, and data science output into business processes and workflows.
  • Develop data strategies and translate 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.
  • Lead planning sessions with customers to improve business processes and prioritize investments in data and infrastructure.
  • Work closely with Technical Review Board and Enterprise Architects to assure all systems are in line with the long-term IT strategy.
  • Proactively analyze existing data structures or reporting to identify weaknesses and develop opportunities for improvements.
  • 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.
  • Develop decision matrix on when to use various data platforms (data warehouse, data mart, big data, or data virtualization).
  • Lead and oversee effort to identify data requirements, develop data specifications, enforce data governance, apply data modeling patterns, develop data conversion and migration designs, and develop 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.
  • Manage multiple priorities of projects and requests.
  • Propose appropriate changes to the enterprise data architecture to keep pace with Business and Market developments.
  • Adhere to data quality standards and data procedures, review data models for data quality assurance and validate compliance with data architecture standards.
  • Define development guidelines and standards for data management on structured and unstructured data sets.
  • Demonstrate project management skills and may serve as a lead on IT projects.
  • Manage and provide Tier III support for reporting, data structures, and related data applications.
  • Provide technical guidance, business process expertise and technical leadership to team members.
  • Establish liaison relationships with business partners and/or suppliers in order to provide technical solutions to meet user needs and influence strategic initiatives.

Requirements

  • Bachelor's degree with 5 years of experience or Certification with 5 years of experience; 7 years of experience if no Bachelor or Certification.
  • Broad level industry knowledge and skills in relational databases, data quality, data governance, data integration, business intelligence reporting, and data visualization.
  • Experience with data management processes and tools like Informatica, Microsoft Data Services, Microstrategy, Tableau, Denodo, Collibra.
  • Knowledge of data quality, data management, data visualization, and predictive analytics concepts.
  • High level understanding of Big Data platforms and applications.
  • Advanced SQL knowledge.
  • Knowledge of various data modeling software tools such as Erwin.
  • Ability to work without supervision, given latitude for independent action, for decision making and for developing solutions.
  • Ability to read and comprehend technical documents, maintain accurate records, prioritize work and analyze problems to develop innovative and effective solutions.
  • Demonstrated initiative to maintain technical currency through outside studies and training.
  • Ability to identify appropriate level of team interactions to resolve issues and lead effective collaboration and meetings.
  • Advanced skill in identifying and resolving technical problems and effectively communicating the problems to vendors, customers, and team members.
  • Excellent communication skills with functional and technical peers, and ability to adapt message to both technical and non-technical audiences.
  • General knowledge of Cyber Security design requirements.
  • Ability to develop and communicate a technical vision that is easily understood by all levels of management.
  • Proven ability to mentor peers to better results and identify appropriate training to improve teams technical bench strength.

Benefits

  • Relocation assistance available
  • Remote eligibility
  • Salary starting at $100,000+
  • Full-time position
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service