Data Architect (W2 only)

Theoris; Indianapolis (IN); On-site; USD 120,000 - 180,000; Full time

Job summary

Theoris is seeking a Data Architect to join our client’s Indianapolis team to define, design, build, and maintain a comprehensive data architecture vision and execution plan. You will collaborate with business units to identify future data uses and drive data strategy across enterprise data domains.

Key responsibilities include developing scalable data models, enabling data exchange with partners, and evaluating cloud-based data platforms and governance practices.

Qualifications

• Bachelor’s degree in computer science or related field.
• 10+ years designing large-scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional).
• 7+ years in several disciplines: statistical methods, data modeling, ontology development, semantic graph construction and linked data, relational schema design.
• Demonstrated SQL and data modeling proficiency.
• Experience with data modeling tools such as ER/Studio, Erwin or TOAD.
• Experience in AWS.
• Experience with security models and development on large data sets.
• Experience with multiple database technologies and solutions (e.g., Postgres, Redshift, Aurora, Athena).
• Experience with Agile Development, CI/CD, Jenkins, Github, Automation platforms.
• Demonstrated ability to analyze large, complex data domains and craft practical analytics solutions.
• Ability to communicate with a geographically dispersed group of business and technical colleagues.
• Knowledge of Data Governance, Master Data Management, Business Intelligence.
• Experience moving on-premises solutions to the cloud.

Responsibilities

• Define data architecture vision, strategy and principles for the enterprise.
• Design, build, and maintain enterprise data models (conceptual, logical, physical & dimensional).
• Collaborate with business to identify future data uses and expected results.
• Develop data domains, data quality, and ontology concepts for organizational data needs.
• Enable scalable data exchange with external partners using industry standards.
• Explore new data technologies to optimize data organization and analysis.

Skills

SQL proficiency

Data modeling

Data governance

Data analytics

Communication

Cloud experience

CI/CD

Education

Bachelor's Degree in Computer Science

Tools

ER/Studio

Erwin

TOAD

AWS

Job description

Theoris Services is assisting our client in their search for a Data Architect to add to their growing team located in Indianapolis. Our client is seeking an individual to assist in defining, designing, building, and maintaining the data architecture vision, strategy, and principles across the enterprise.

Responsibilities:

• Data/Information Vision and Strategy includes the ability to work with business to identify future uses for organizational data and anticipated business results and enable processes to support these needs.
• Data Planning/Modelling and Data Lifecycle Design includes the ability to develop a technical strategy for future data structure and data integration.
• Develop and provide expertise in enterprise data domains; this includes data relationships, data quality, understanding of business data needs and the associated technology toolsets and methodologies.
• Develop understanding how the enterprise data strategies, platforms, and technologies enable business execution. Use this knowledge to appropriately challenge status quo and drive business and collaborations.
• Analyze data from multiple domains; discover trends and associations, synthesize new integration constructs that assist non-expert users to find similar trends and associations.
• Facilitate efficient and scalable data exchange between the organization and its external partners using industry standards and data integration methodologies.
• Use cutting edge information technologies to organize and analyze data
• Extend publicly available data sets, ontologies, and taxonomies for internal use.
• Continuously scan the technology environment for new trends and techniques; interface with external consultants and thought leaders as needed.
• Synthesize new scalable approaches for organizational data integration; derive the supporting arguments, communicate, and articulate the reasons for the new approaches to fellow engineers as well as senior management.

Requirements:

• Bachelor’s Degree in computer science or related scientific discipline.
• 10+ years of experience designing large scale data models for functional, operational, and analytical environments (Conceptual, Logical, Physical & Dimensional)
• 7+ years of experience in several of the following disciplines: statistical methods, data modeling, ontology development, semantic graph construction and linked data, relational schema design.
• Demonstrated SQL and data modeling proficiency.
• Experience with data modeling tools such as, ER*Studio and Erwin or TOAD
• Experience in AWS.
• Experience with security models and development on large data sets
• Experience with multiple database technologies
• Experience with multiple database solutions (e.g. Postgres, Redshift, Aurora, Athena) and formal database designs (3NF, Dimensional Models)
• Experience with Agile Development, CI/CD, Jenkins, Github, Automation platforms
• Demonstrated ability to analyze large, complex data domains and craft practical solutions for subsequent data exploitation via analytics.
• Demonstrated ability to communicate with a geographically dispersed group of business and technical colleagues
• Ability to review and provide practical recommendations on design patterns, performance considerations & optimization, database versions, and database deployment strategies
• Knowledgeable in data functions such as Data Governance, Master Data Management, Business Intelligence
• Experience in moving on premises solutions into cloud and knowledge in multiple data ingestion patterns

Additional Preferences:

• CDMP Certification
• AWS Solution Architect

We are in the people business; treating people right is our ONLY priority. Theoris Services consultants are full-time employees with full benefits, including: