Data Architect - Remote

Job ID:  506384

Exempt

Oldcastle Infrastructure™, a CRH company, is the leading provider of utility infrastructure solutions for the water, energy, and communications markets throughout North America. We’re more than just a manufacturer of precast concrete, polymer concrete, or plastic products. We’re a trusted and strategic partner to engineers, contractors, distributors, specifiers, and more. With our network of more than 80 manufacturing facilities and more than 4,000 employees, we’re leading the industry with innovation and a safety-first mindset.

Our strategic focus on a combination of acquisition and organic growth along with our adoption of cloud-based technologies has quickly led to a massive shift toward rapid integration and delivery as a necessity to the business. To meet these challenges, we are building an “elite” engineering team that will welcome the challenges to engineer, integrate, secure, operate and enhance these environments and to deliver exceptional and expedient value to the business while maintaining the delivery and direction of the overall IT strategy.

Job Summary

The Data Architect position will partner with IT and business to support the continued growth and success of the enterprise in a robust and cohesive team. In order to be successful, the data architect will need to demonstrate both business acumen and technological insight to execute our global data strategy. Regular activities will include data analysis, logical & physical data modeling, data profiling, and database design and metadata usage.

Reporting within the Data & Analytics team, the role will be responsible for design, management and security of our data globally across technology platforms and in both on-premise and cloud solutions, including working across departments and working in matrix/agile project teams. 

Job Responsibilities

• Serve as overall data expert across all database technologies (Oracle, SQL Server, NoSQL, etc.) and market capabilities/trends

• “Champion” data efforts around governance and quality of data

• Lead and participate in gathering business and data requirements

• Lead analysis of source systems, performing thorough Data Profiling and Data Quality analysis

• Ongoing analysis of data requirements and development of appropriate logical and physical data models for both relational and non-relational data structures

• Define underlying data sources and transformation requirements for data integration

• Develop and ensure compliance with data modeling best practices and standards

• Document Metadata and Business Glossary for business/subject area supported

• Data Management activities including optimizing physical database design for performance & performance tuning of existing data structures

• Facilitating data governance and master data management teams/initiatives

Job Requirements

• Bachelor's Degree in Computer Science, Mathematics, Statistics or related field.

• 10+ years’ experience as a data architect leading large scale data initiatives

• 10+ years of experience architecting data warehouse platforms (DWH/EDW).

• 2+ years’ experience with Cloud-based database designs and implementations (Azure, Amazon, Google)

• Expert-level hands on experience in data modeling; logical and physical in both OLTP, Dimensional and non-relational structures

• “Expert-level” SQL (Structured Query Language) and data extraction skills – ability to extract and manipulate data from common data base systems (Oracle, SQL Server, Salesforce, SAP, etc.)

• Superior analytical and problem solving skills

• Experience with agile style project management techniques

• Ability to work independently or in a group setting

• Strong interpersonal skills with an ability to build business relationships

• Excellent verbal and oral communication skills with both technical and non-technical colleagues from geographically distributed teams on all organizational levels.

What CRH Offers You

• Highly competitive base pay
• Comprehensive medical, dental and disability benefits programs
• Group retirement savings program
• Health and wellness programs
• A diverse and inclusive culture that values opportunity for growth, development, and internal promotion

About CRH

CRH has a long and proud heritage. We are a collection of hundreds of family businesses, regional companies and large enterprises that together form the CRH family. CRH operates in a decentralized, diversified structure that allows you to work in a small company environment while having the career opportunities of a large international organization.

If you’re up for a rewarding challenge, we invite you to take the first step and apply today! Once you click apply now, you will be brought to our official employment application. Please complete your online profile and it will be sent to the hiring manager. Our system allows you to view and track your status 24 hours a day. Thank you for your interest!

Oldcastle Infrastructure, a CRH Company, is an Affirmative Action and Equal Opportunity Employer.

EOE/Vet/Disability--If you want to know more, please click on this link.