Share this Job
Apply now »

Title:  Enterprise Data Architect

Requisition ID:  116584
Location: 

Phoenix, AZ, US, 85004-2121

Category:  Information Systems
Description: 

Freeport-McMoRan is a leading international mining company with headquarters in Phoenix, Arizona. We operate large, long-lived, geographically diverse assets with significant proven and probable reserves of copper, gold, and molybdenum. The company has a dynamic portfolio of operating, expansion and growth projects in the copper industry. Freeport-McMoRan is one of the world’s largest publicly traded copper producers, the world’s largest producer of molybdenum and a significant gold producer. We have a long and successful history of conducting our business in a safe, highly efficient and socially-responsible manner. We have the assets, the talent, the drive and the financial strength to provide attractive and rewarding careers of our employees. We encourage you to take the time to explore the opportunity to advance your career at Freeport-McMoRan.

We have the assets, the talent, the drive and the financial strength to provide attractive and rewarding careers of our employees. We encourage you to take the time to explore the opportunity to advance your career at Freeport-McMoRan.

Please note: This position has the possibility of working remotely within 150 miles of Phoenix, Arizona for a percentage of the scheduled work time, as determined by the supervisor. If hired, you will be required to comply with Freeport-McMoRan’s requirement of all employees who are working or attending a meeting onsite at a corporate office location, to submit proof that they are fully vaccinated against COVID-19 prior to entry, unless the company has granted them a medical or religious accommodation.

Description

You will lead a global fast-growing Data Architecture and Modeling team pursuing a vision of analytics-driven mining at Freeport. Your expertise in data warehouse architecture, data modeling, and ETL will enable and empower our organization to maintain a robust and trusted Enterprise Data Warehouse. At Freeport we understand that our data does not reach its full potential until it is analyzed, and insights effectively communicated to the enterprise. You will work in close collaboration with subject matter experts, data engineers, business intelligence analysts, data scientists, and software engineers to develop advanced, highly automated data products. You will be a champion of Data Modeling, Data Cataloging, DataOps, DevOps, and agile practices; mentoring team members to realize their full potential.

  • Leadership: Develop and lead a global team of Data Architects and ETL Developers to design, develop, deploy, and monitor enterprise data models and ETL pipelines. Ensure agile teams are properly staffed to deliver on time by defining clear development patterns and architectural guidelines, maintaining a roadmap for execution, and actively secure its implementation through the scrum process. Cultivate a generative culture that values customer centric continuous improvement through experimentation and self-guided learning. Act as a positive coach/mentor for broader organization to develop a stronger understanding of the data modeling and ETL design patterns that create scalable, maintainable, well-designed data warehouses.
  • Architecture: Influence, develop, and sustain large-scale data warehouse architecture required for delivering a robust enterprise data model with high quality, trusted data. Establish software architecture and design patterns to write scalable, maintainable, well-designed processes. Relentlessly identify and remove friction in the data warehouse development lifecycle to improve developer experience and ensure the quality of enterprise data. Research and evaluate tools in data warehousing, ETL, automated CI/CD, data quality monitoring, and data serving.
  • Agile Project Work: Work in cross-functional, geographically distributed agile teams to continuously innovate analytic solutions.
    • Drives the development of data requirements through data modeling techniques and structuring working sessions. Collaborate with others then take action to express data requirements as 3rd Normal Form logical data models through review of source system documentation, review of system features and workshop sessions with business partners.
    • Develop, review, and secure documentation of Data Lineage and Data Dictionaries to create a broad awareness of the enterprise data model and its applications
    • Create physical databases design for the Snowflake data warehouse and other database technologies in partnership with other technical resources.
    • Design, develop, and review real-time/bulk data pipelines from a variety of sources (streaming data, APIs, data warehouse, messages, images, video, etc)
    • Partner with key business SMEs to build and manage the workgroup database view library by building relevant data shapes in SQL
    • Actively champion and apply best practices within DataOps (Version Control, P.R. Based Development, Schema Change Control, CI/CD, Deployment Automation, Test Automation, Shift left on Security, Loosely Coupled Architectures, Monitoring, Proactive Notifications)
    • Coordinate with other teams to design optimal patterns for data ingest, transformation, and egress as well as lead and coordinate data quality initiatives and troubleshooting
    • Guide problem solving sessions, ensuring alignment to North Star. Provide mentorship and coaching to junior team members.
    • Proactively adapt team makeup to increase project velocity and solution quality.

Qualifications

Minimum Requirements:

  • Bachelor’s degree in engineering, computer science, analytical field (Statistics, Mathematics, etc.) or related discipline and seven (7) years of relevant work experience, including (3) years of project management/leadership experience OR
  • Master’s or Ph.D. in engineering, computer science, analytical field (Statistics, Mathematics, etc.) or related discipline and five (5) years of relevant work experience, including (2) years of project management/leadership experience
  • Strong verbal and written skills in English language.
  • Expert knowledge of data model using IDEF1X or similar data modeling methodologies.
  • Experience influencing and building mindshare convincingly with any audience. Confident and experienced in public speaking to large audiences
  • Experience leading and developing teams
  • Experience leading joint design sessions and working in groups
  • Experience with data modeling tools like ER Studio or ERwin.
  • Expert practitioner of SQL development

 

Preferred Qualifications:

  • Proficient practitioner of Python development
  • Working knowledge of Software Engineering and Object Orient Programming Principles
  • Working knowledge of Parallel Processing Environments such as Snowflake or Spark SQL.
  • Working knowledge of problem solving/root cause analysis on Production workloads
  • Working knowledge of Agile, Scrum, and Kanban
  • Working knowledge of enterprise scheduling and workflow orchestration using tools such as Airflow, Prefect, Dagster, or similar tooling
  • Working knowledge with CI/CD and automation tools like Jenkins or Azure DevOps

 

Criteria/Conditions:

  • Must be able to frequently sit, stand and walk.
  • Must be able to frequently lift and carry up to 10 pounds.
  • Must be able to work in a potentially stressful environment.
  • Personal protective equipment is required when performing work in a mine, outdoor, manufacturing or plant environment, including hart hat, hearing protection, safety glasses, safety footwear, and as needed, respirator, rubber steel-toe boots, protective clothing, gloves and any other protective equipment as required.
  • Freeport-McMoRan promotes a drug/alcohol-free work environment through the use of mandatory pre-employment drug testing and on-going random drug testing as allowed by applicable state laws

Freeport-McMoRan has reviewed the jobs at its various office and operating sites and determined that many of these jobs require employees to perform essential job functions that pose a direct threat to the safety or health of the employees performing these tasks or others.  Accordingly, the Company has designated the following positions as safety-sensitive:

  • Site-based positions, or positions which require unescorted access to site-based operational areas, which are held by employees who are required to receive MSHA, OSHA, DOT, HAZWOPER and/or Hazard Recognition Training; or
  • Positions which are held by employees who operate equipment, machinery or motor vehicles in furtherance of performing the essential functions of their job duties, including operating motor vehicles while on Company business or travel (for this purpose "motor vehicles" includes Company owned or leased motor vehicles and personal vehicles used by employees in furtherance of Company business or while on Company travel); or
  • Positions which Freeport-McMoRan has designated as safety sensitive positions in the applicable job or position description and which upon further review continue to be designated as safety-sensitive based on an individualized assessment of the actual duties performed by a specifically identified employee.

Equal Opportunity Employer/Protected Veteran/Disability


Job Segment: Test Engineer, Data Warehouse, Testing, Computer Science, Database, Engineering, Technology

Apply now »