Data and Analytics Architect

Req ID:  61868

Houston, TX, US, 77041

Date:  Nov 25, 2021

<span 72="">For over 140 years our products have helped ensure the safe, reliable operations of key industries. With a passion for precision and partnership, Celeros Flow Technology continues this heritage of high performance and dependability, providing mission critical, sustainable flow control solutions for our customers around the globe.


<span 72="">Celeros Flow Technology is looking for individuals with a voice and a vision. We embrace change, diversity and promote new ways of looking at old ideas. We seek talented professionals to join our world-class team of innovators in a global, collaborative & multi-cultural environment, where you will be challenged, supported, and inspired to be extraordinary. 

Data and Analytics Architect


We are looking for a Data and Analytics Architect who excels at helping organizations design, implement, and execute data rich enterprise-wide data and analytics solutions to achieve competitive advantages. This individual must be able to work directly with global business stakeholders to comprehensively understand their processes and build rock solid data and analytics architecture and solution to drive trusted company metrics and decisions. Key to success is building a Data and Analytics Strategy and Architecture that ingests data from transactional systems like SAP, AS/400, QuickBooks and IIoT sources, and aggregates them into meaningful decision making datastores which can be easily consumed – in a self-service manner – by all functional areas.


Key Responsibilities


The Data and Analytics Architect will be responsible for understanding and translating business strategies and priorities into design and architecture which will include building a modern data analytics platform, creating data model for reporting, mapping data in the source systems, working on development of extraction and load of data in the data warehouse, ensuring data quality and accessibility, and developing reports and dashboards that will provide data insights and help drive key decisions for the business users and senior leadership at Celeros FT. This person will be working closely with the team of data analytics analysts and developers, while reporting to the Director of Digital, Data and Analytics and helping develop a world class data and analytics practice. This person will also have direct oversight of data and analytics projects and ensure all project work is completed as per the plan and deadlines. In a nutshell, we are looking for someone who is hands-on with data and analytics architecture and solution, a great team player and have ability to lead teams and projects. Some of the responsibilities for this role will include:


  • Design and develop robust, high-performance, and future-proof data and analytics platform and solutions.
  • Understand and deliver work as per expectations of business users and leadership team.
  • Translate business goal, needs, and metrics into data management, analytics functions, and requirements. Translate business requirements into data mapping in source ERP systems and designs for reports and dashboards.
  • Gather and translate business requirements into technical specifications using structure techniques and data warehousing methodology.
  • Develop the enterprise’s capacity to develop insights from analytics.
  • Create conceptual, logical, and physical data models scalable across the Enterprise.
  • Develop, maintain, and support data warehouse and data mart structure.
  • Assist and guide ETL developer with developing and testing SAP BODS (BusinessObjects Data Services) dataflows. Work on development of ETL dataflow and develop reports and dashboards with Power BI when needed.
  • Create, publish, and maintain the corporate information architecture and a roadmap for its future development.
  • Define and enforce data modeling and architecture standards, procedures and policies to ensure consistency across project implementations.
  • Establish governance and best practices for ingesting and staging enterprise and IIoT data, data management, consumption patterns, and data security.
  • Assess data quality, create a plan for profiling, monitoring and continuous improvement of data quality. Work with key stakeholders and teams to improve data quality.
  • Recommend Master Data Management practices for the company. Measure master data and reference data for compliance to policy, standards, and models.
  • Collaborate with other IT and non-IT groups in data integration and enterprise information management to support reuse.
  • Oversee the day-to-day running of all data and analytics tools and assets, including enforcing policies, security, maintaining systems, and responding to user requests. Ensure system delivers consistently on the service level agreements.
  • Demonstrate a passion for learning new technology and toolsets.


Required Skills:

  • Strong business acumen with 10+ years of experience delivering data and analytics solutions.
  • 10+ years of experience with OLTP and OLAP database models, and enterprise data modeling. 
  • 5+ years of experience working with SQL server, database schemas and ETL.
  • 3+ years of experience leading projects to deliver data analytics solutions to business.
  • Deep understanding of data warehousing and data modeling, data integration/ETL, design, development, data governance, data integrity, data quality, MDM, data security and classification, and best practice for building reporting and analytics.
  • Deep knowledge and experience of SAP data dictionary and transactions in FICO (including GL and COPA), SD, MM, Purchasing, PP, PM, and WM.
  • Experienced in database and data warehouse optimization and performance tuning.
  • Hands-on experience with designing and developing reports and dashboards using Power BI.
  • Strong problem solving, time management and organizational skills.
  • Solid soft skills and the ability to work with a global team, mentor technical team members and support global teams and managers.
  • Proven ability to work with business stakeholders to explain data and analytics concepts and solutions.
  • Experience working with data and analytics in manufacturing industry.
  • Quick learner of new data analytics technology and business process.


Preferred Skills:

  • Experience with developing ETL dataflow using SAP BusinessObjects Data Services.
  • Experience in data profiling, documenting data lineage from data sources to reporting repository, using data quality tools such as SAP Information Steward.
  • Hands-on experience in Azure, GCP and/or other cloud data and analytics platform architecture and ML/AI capabilities is preferred.
  • Experience working with IoT, data lakes, NoSQL database, big data and distributed databases is preferred.
  • Experience working with data and analytics in energy or oil & gas industry.



  1. 4 Year degree in Information Systems/Data Science/Computer Science.
  2. 15+ years of experience in IT related field including 10+ years of experience of delivering Data and Analytics solutions and 5+ years of experience as a Data and Analytics architect.



Required Education

Bachelor's degree in Information Systems/Data Science/Computer Science.

Celeros Flow Technology is an equal opportunity employer. All aspects of employment including the decision to hire, promote, discipline, or discharge, will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law.

Nearest Major Market: Houston