As a Data Model Architect in Credera’s Data Engineering capability group, you will create data models optimized for analysis in modern data architecture and advanced analytical solutions.   This includes designing how data is organized, stored, and retrieved to best support business objectives, as well as visually representing data objects and their associations with different data objects and rules.  Our projects range from designing and implementing the latest data platform approaches (i.e. Lakehouse, DataOps, Data Mesh) using best practices and cloud solutions, building scalable data and ML pipelines, democratizing data through modern governance approaches, and delivering data products using advanced machine learning, visualization, and integration approaches.

WHO YOU ARE:

• You have a minimum 3 years of experience in data architecture, data modeling, and data lake/warehouse architecture (5 years is a plus)
• You have 3-5 years of experience in data engineering, data analysis, ETL or similar role delivering data pipelines
• You have experience in a business-facing role, demonstrating strong communication and presentation skills
• You have the ability to work in a fast-paced, consulting-style, entrepreneurial environment
• You have experience with Cloud SQL Warehouses (Snowflake, BigQuery, Redshift, Synapse) and / or Lakehouse (Databricks, AWS Lakeformation, etc). Nice to have (Graph, Vector, Document database architectures)
• You have an excellent understanding of data modeling concepts, including Entity-Relationship diagrams, Domain/Subject/Object modeling, and SQL/DDL scripting
• You have proficiency in data integration and transformation techniques and experience with ELT tools like Fivetran and dbt
• You have proven ability to mentor and train others in a complex technical environment
• You have excellent problem-solving skills, attention to detail, and strong organizational skills
• You have a proven track record in driving decision-making process with influence and leadership
• You have a bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field
• Certifications in relevant technologies and platforms would be a plus, such as AWS Certified Big Data or Google Cloud Certified Data Engineer

WHO WE ARE:

• Credera is a full-service management consulting, user experience, and technology solutions firm, with clients ranging from Fortune 500 companies to emerging industry leaders
• Credera has received a number of state and national awards! Please check out our employer awards at: https://www.credera.com/awards-and-recognition
• Our data capabilities help our clients gain competitive advantage by transforming raw data into insights that enable actionable decision making. Our business-driven approach to envisioning and implementing innovative solutions helps organizations tackle their market, increase customer engagement and grow revenue profitably via advanced technology. Our data capabilities serve our clients across a broad spectrum of areas, specializing in Data Strategy, Modern Data Architecture, Data Visualization, Business Insights, Data Analytics and Artificial Intelligence. 

HOW WE WORK:

• We work in small (typically 2-8 person) project teams that collaborate closely with clients to solve their toughest challenges
• We employ principles of agile development to achieve high velocity and quality of delivery
• We offer several channels for collaboration that make it easy to reach out to leaders within the practice
• We adhere to Credera’s core values of integrity, excellence, professionalism, and humility at all times

Hybrid Work Model:

Our employees have the flexibility to work remotely two days per week. We expect our Crederians to average 3 days (full or partial) per week in person with the flexibility to choose the days and times that work best for both them and their project or internal teams. This could be at a Credera office, at a client site, or at an off-site location with other team members. You’ll work closely with your project team to align on how you balance both the flexibility that we want to provide with the connection of being together to produce amazing results for our clients.
The why: We are passionate about growing our people both personally and professionally. Our philosophy is that in-person engagement is critical for our ability to develop deep relationships with our clients and our team members – it’s how we earn trust, learn from others, and ultimately become better consultants and professionals.

Travel: Our goal is to keep out-of-market travel to a minimum and most projects do not require significant travel.  While certain projects can require frequent travel (up to 80% for a period of time), our average travel percentage over a year for team members is typically between 10-30%. We try to take a personal approach to travel. You will submit your travel preferences which our staffing teams will take into account when aligning you to a role.

Responsibilities:

• Collaborate with management consultants and business analysts to define and translate complex strategic, functional, and technical requirements into detailed architecture and data model designs
• Collaborate with business stakeholders and subject matter experts to define / design data models for analytical use and the tech stack to prepare data, as part of a broader data strategy or individual project and assessing client readiness to execute
• Translate business priorities into clearly defined key performance indicators
• Decide between and designing data models for various technology architectures, including MPP / Cloud SQL Warehouses, Lakehouse, Graph, and Vector/Document databases, streaming data
• Decide between and define various data modeling patterns (Star/Snowflake Schema, Data Vault 2.0, Wide Flat Table, Lakehouse, Nested documents, etc)
• Lead data transformation efforts to convert raw data into meaningful information for analytics that drive actionable insights
• Design and implement analytical data models optimized for performance, scalability, and data analysis and aligned to business goals
• Lead Data Democratization efforts for organizations to drive usage of data models and platforms, including data reliability, protection, discovery, and self service tooling
• Teach and mentor junior and senior data engineers on data modeling techniques and data transformation strategies
• Cross-train application data architects and other team members on modern data platforms, data modeling techniques, and tools

Learn More

Credera is a management consulting, user experience, and technology solutions firm with offices in Dallas, Denver, Houston, Chicago, Los Angeles, San Francisco, Seattle, Atlanta, and New York. We work with clients ranging from Fortune 500 companies to emerging industry leaders, and provide expert, objective advice to help solve complex business and technology challenges. Our deep capabilities in strategy, organization, process, analytics, technology and user experience help our clients improve their performance. Clients depend on our ability to anticipate, recognize, and address their specific needs. Credera’s consultants work with some of the world’s best known brands in a variety of industries, including one of the top five fast food chains, leading energy organizations, retailers, airlines.  More information is available at www.credera.com.  We are part of the OPMG Group of Companies, a division of Omnicom Group Inc.

Along with a great company culture, Credera provides an outstanding compensation package including a competitive salary and a comprehensive benefit plan (e.g., medical, dental, disability, matching 401k, PTO, etc.).  This position is an exempt position. 

Credera will never ask for money up front and will not use apps such as Facebook Messenger, WhatsApp or Google Hangouts for communicating with you. You should be very wary of, and carefully scrutinize, any job opportunity that asks for money prior to starting and/or where all communications take place exclusively via chat.