Senior Data Architect (SDA)

Genesis10 is seeking a Data Architect for our client in the utilities industry. This long term contract position is located in Dallas TX 77202. Hybrid schedule 2-3 days onsite.

W2 Hourly Pay rate range: ($85-120/hr Depending on experience )

Description:

We are seeking a Data Architect to own the strategic design and governance of our enterprise data landscape built on Oracle on-premise database platforms and modeled using Erwin. This role sits above individual project data models: you will define the enterprise-wide data architecture standards and target operating model that all data modelers engineers and DBAs build against while personally handling the highest-complexity highest-volume modeling and architecture decisions across the organization. You will bring proven experience architecting for large-scale data volumes (multi-GB to multi-TB) regulated environments and the performance scalability and integrity demands that come with them. You will also be responsible for assisting in development and management of Data Governance and Master Data Management solutions. You must be comfortable presenting deep technical concepts to non-technical leadership i.e. have good technical and communication skills coupled with the ability to provide technical mentorship.

Key Responsibilities

Data Architecture & Data Strategy

• Define and own the enterprise data architecture strategy including target-state data models subject area models and reference architectures across the Oracle on-premise estate.
• Establish enterprise-wide data modeling standards naming conventions and governance policies within Erwin and ensure consistent adoption across data modeling and engineering teams.
• Own the enterprise Erwin model repository/mart: subject area organization model versioning complex merges and cross-model consistency at scale.
• Partner with stakeholders (Application Teams Enterprise Architecture business unit leaders) to translate business strategy into a coherent long-term data architecture roadmap.
• Evaluate and architect for scalability performance and maintainability of Oracle databases handling large data volumes (GB to multi-TB scale) including partitioning indexing and storage strategy at the architectural level.
• Assist in promoting the Data Architecture function to increase the adoption of Data Virtualization (Denodo) across the enterprise.

Data Modeling & Design Oversight

• Design and review conceptual logical and physical data models for the most complex cross-functional and high-volume domains in the enterprise.
• Provide architectural review and approval of data models produced by senior/staff data modelers ensuring alignment with enterprise standards referential integrity and downstream performance implications.
• Lead reverse-engineering and rationalization efforts for large legacy Oracle schemas consolidating and simplifying where architecturally sound.
• Guide both OLTP/3NF and dimensional (star/snowflake) modeling approaches selecting the right pattern for transactional operational and analytical workloads.

Governance Performance & Risk

• Assist in enriching the enterprise data governance artifacts tied to the architecture: business glossary data lineage metadata repository and data dictionary standards.
• Lead capacity planning and performance architecture for large Oracle databases anticipating growth in data volume and ensuring the model and physical design scale accordingly.
• Assess and mitigate architectural risk in schema changes at enterprise scale including impact analysis across integrated systems.
• Ensure data architecture practices meet regulatory security and compliance requirements applicable to the industry.
• Establish policies procedures and guidelines regarding all aspects of Data Governance

Master Data Management

• Assist in establishment of policies procedures and guidelines regarding all aspects of Master Data Management
• Ensure Architectural rules and design of the MDM process are documented and best practices are adhered to.
• Developing a strategic roadmap for MDM and assisting in developing a roadmap and its implementation

Leadership & Collaboration

• Mentor and provide technical direction to data modelers ETL developers and DBAs on modeling best practices Erwin usage and Oracle architecture patterns.
• Act as the primary architectural liaison between business stakeholders application teams DBAs and infrastructure teams.
• Present architecture decisions trade-offs and roadmaps to senior leadership and non-technical stakeholders.
• Provide mentorship to Data Analysts to ensure data management and design best practices are adhered to.
• Collaborate with support teams to ensure consistent and proactive support methodologies are in place for all aspects of data movement and data transformation.

Required Qualifications

• 10 years of experience in data architecture data modeling or database engineering including prior experience as a senior/lead data modeler solution architect or data architect.
• Deep hands-on expertise with Erwin Data Modeler at an enterprise scale (model mart subject areas complex compare/merge versioning across large teams).
• Strong expertise in Oracle Database (on-premise) including advanced SQL/PL-SQL schema design partitioning indexing strategy and performance tuning at the architectural level.
• Demonstrated experience architecting and modeling for large data volumes (GB to multi-TB scale) with a track record of designs that scaled successfully in production.
• Strong command of data modeling theory (normalization/denormalization cardinality keys referential integrity) and dimensional modeling (star/snowflake) for analytics.
• Experience defining enterprise data standards governance frameworks and metadata/lineage practices.
• Extensive working knowledge of all aspects of Data Movement and Processing including Middleware ETL API OLAP and best practices for data tracking
• Proven ability to operate at the intersection of technical architecture and executive stakeholder management i.e. translating business strategy into data architecture and communicating trade-offs to leadership.
• Strong written and verbal communication skills with experience producing architecture documentation ER diagrams and data dictionaries for both technical and business audiences.

Preferred Qualifications

• Experience in a regulated industry (utilities financial services insurance healthcare) with associated data governance and compliance obligations.
• Experience leading or mentoring a team of data modelers/architects.
• Previous experience working with PostGres and MongoDB and big plus.
• Familiarity with complementary data modeling tools such as ER/Studio Power Designer Collibra Alation
• Exposure to hybrid on-prem/cloud data strategies even where the primary platform remains Oracle on-premise.
• Experience with Target Operating Model (TOM) design for data functions.
• Relevant certifications (OCI DAMA CDMP etc.) is a plus.
• Experience with Hadoop/MongoDB is a plus
• Working experience with Denodo is a plus

Team Culture: Our team is fast paced fun highly energetic motivated and hardworking. We expect our candidates to be integrated into our results-driven and solution-oriented culture from the get-go. Our team attains high-quality results on challenging projects; the belief that outcomes are linked to ones effort rather than chance and the tendency to personally set challenging yet realistic goals.

Only candidates available and ready to work directly as Genesis10 employees will be considered for this position.

If you have the described qualifications and are interested in this exciting opportunity please apply!

Ranked a Top Staffing Firm in the U.S. by Staffing Industry Analysts for six consecutive years Genesis10 puts thousands of consultants and employees to work across the United States every yearin contract contract-for-hire and permanent placement roles. With more than 300 active clients Genesis10 provides access to many of the Fortune 100 firms and a variety of mid-market organizations across the full spectrum of industry verticals.

Benefits of Working with Genesis10:

• Access to hundreds of clients most who have been working with Genesis10 for 5-20 years.
• The opportunity to have a career-home in Genesis10; many of our consultants have been working exclusively with Genesis10 for years.
• Access to an experienced caring recruiting team (more than 7 years of experience on average.)
• Behavioral Health Platform
• Medical Dental Vision
• Health Savings Account
• Voluntary Hospital Indemnity (Critical Illness & Accident)
• Voluntary Term Life Insurance
• 401K
• Sick Pay (for applicable states/municipalities)
• Commuter Benefits (Dallas NYC SF & Illinois)

For multiple years running Genesis10 has been recognized as a Top Staffing Firm in the U.S. as a Best Company for Work-Life Balance as a Best Company for Career Growth for Diversity and for Leadership amongst others. To learn more and to view all our available career opportunities please visit us at our website.

Genesis10 is an Equal Opportunity Employer. Candidates will receive consideration without regard to their race color religion sex sexual orientation gender identity national origin disability or status as a protected veteran
#DIG10-DA

Required Experience:

Senior IC