Enterprise Data Architect

Job Description

The Enterprise Data Architect has an advanced understanding of the methodologies and techniques relevant to designing, creating, deploying, and managing Ent's data architecture.

The end result will enable Ent to meet or exceed various business strategies. This resource will work primarily on agile teams with project managers, product owners, data engineers, business intelligence analysts, data scientists, and developers.

Essential Functions

Database and Data Lake architecture / design : Initiate / recommend the collection of new data sources or modification of existing data sources to solve business problems.

Architect database and / or data lake schemas to ensure data is stored in an efficient manner that aligns with the business objectives and allows rapid, actionable insights.

Consult with Data Engineers on pipeline development ensuring data mappings align with the expected schemas. Consult with Data / BI analysts and Data Scientists to ensure data schemas and pipeline processing meet the needs of downstream analytical processes.

Design and optimize high performing data models for different consumption patterns from the data stores (databases and / or data lakes).

Act as subject matter expert for ALL data flowing into Ent's data warehouse / lakehouse.

Business Partnership / Communication : Develop partnerships with the consumers of Ent's data assets to understand business needs.

Facilitate schema development that aligns with business definitions. Document how schemas map to business data sources.

Architectural Patterns and Practices : Document various architectural patterns and practices for use throughout the Data & Analytics teams.

Perform periodic checks to ensure Data Engineers are following best practices as documented, including participating in code reviews on occasion.

Data Governance : Work closely with the Data Governance committee in helping define data standards and policies. Ensure any design / development adheres to the Data Governance standards / policies.

Help ensure the data integrity of data at all stages (ingestion to presentation). Help ensure data is secure and only accessible within guidelines set forth by the Data Governance committee.

Help document current data processes, including data flow diagrams and data dictionaries.

• Technical Lead : Increase team effectiveness by providing consulting expertise and technical mentoring across multiple verticals.
• Bank Secrecy Act : Remains cognizant of and adheres to Ent policies and procedures, and regulations pertaining to the Bank Secrecy Act.

Qualifications

Minimum Formal Qualifications for this Position

• Bachelor's Degree with an emphasis on coursework of a quantitative nature i.e. Business Analytics. Statistics. Information Systems. Or a related area.
• 8+ years' experience with Management Information Systems, Computer Science, Data Analytics, or similar relevant field to include :
• 4+ years' Data modeling / design / architecture experience.
• 2+ years working with an enterprise-wide Data Governance initiative (Preferred)
• 2+ years Financial Institution experience (Preferred)

Each year of relevant work experience may be exchanged for a year in a relevant degree program or vice versa. For example, a requirement of a bachelor's degree in accounting and 2+ years of account experience could be substituted for a high school diploma and 6 years of relevant accounting work experience or a master's degree in accounting and 0 years of work experience.

Technical or Specialized Knowledge / Skills :

• Data Architecture / Design core skills :
• Expert-level data requirement gathering skills (the ability to glean data requirements from various business stakeholders and subsequently ensure delivery of the expected data assets).
• Expert-level data modeling skills including demonstrated experience with : Relational data modeling (such as database Entity-Relationship Diagrams).

Data Warehouse star schema modeling. Data Lake design and implementation. Data pipeline design patterns and architecture.

• Data Governance core skills :
• Deep understanding of and demonstrated experience with enterprise Data Governance initiatives.
• Thorough understanding of and demonstrated experience with data security at multiple layers. Database and Data Lake access controls (such as RBAC, SQL Schema boundaries, etc.

Data encryption (such as SQL Always Encrypted and / or SQL TDE). Data hashing.

• Thorough understanding of and demonstrated experience with data quality standards / best practices.
• Thorough understanding of and demonstrated experience with data retention processes.
• Data Engineering core skills :
• Development and maintenance of various data pipeline processes, including targeting / sourcing data to / from a wide-variety of systems and file types.
• Thorough understanding of data pipeline patterns and practices.
• Advanced knowledge of and demonstrated experience with the following technologies :
• Modern data warehouse concepts and practices.
• SQL query syntax (ANSI SQL, TSQL, or other well-known SQL implementation).
• SQL Server database administration in on-prem and Azure environments, including : Performance tuning. Index optimizing.

Query analysis. Job monitoring.

• Microsoft SQL Server Integration Services (SSIS), Azure Data Factory, or similar.
• Development tools such as Microsoft Visual Studio.
• Version control systems, preferably Azure DevOps (formerly VSTS) and TFVC and / or Git.
• Agile development processes, such as Scrum or Kanban.
• Other skills :
• Must be able to work independently to deliver complete system solutions and provide guidance within technical area, applying in-depth knowledge of multiple technologies, as appropriate.
• Must be comfortable working in highly collaborative environments.
• Must be able to conduct presentations in group settings in a professional and courteous manner.
• Must be able to learn new and emerging concepts very quickly.
• Must be able to maintain good productivity in developing efficient code and database designs in a very timely manner, with defect rates kept to a minimum.
• Experience acting as a consultant to other professionals in IT, providing technical leadership in their area of specialization.

preferred) Knowledge of Databricks, including DeltaLake concepts.

preferred) Knowledge of programming languages such as C#, Python, Scala, Spark SQL, etc.

Certifications Required :

• MCSE SQL Server (2016 or later) or similar certification preferred
• Azure Data Engineer or similar certification (Preferred)
• Databricks (Associate or Professional) (Preferred)

Environmental, Physical and Psychological Requirements

• Standing - Occasionally
• Walking - Occasionally
• Sitting - Frequently
• Lifting - Rarely (40 Lbs)
• Carrying - Rarely
• Pushing - Rarely
• Pulling - Rarely
• Balancing - Rarely
• Stooping - Rarely
• Kneeling - Rarely
• Crouching - Rarely
• Crawling - Rarely
• Reaching - Occasionally
• Handling - Occasionally
• Grasping - Occasionally
• Feeling - Occasionally
• Talking - Frequently
• Hearing - Frequently
• Repetitive Motions - Frequently
• Eye / Hand / Foot Coordination - Occasionally
• Noises louder than normal speaking volume - Occasionally
• Temperature Changes - Rarely
• Atmospheric Conditions - Rarely

Additional Information

The pay range for this position is : $118,414 to $155,413 per Year (I18)

Final compensation for this position will be determined by various factors such as relevant work experience, specific skills and competencies, education, certifications, and internal pay equity.

This position is eligible for our corporate bonus program based on company performance.

We anticipate this position to close on 10 / 5 / 2024. Please submit your application at your earliest convenience to be considered.

Equal Opportunity Employer / Protected Veterans / Individuals with Disabilities.

Benefits Summary Sheet - 2024

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant.

However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)