Enterprise Data Warehouse (EDW) Lead Data Architect

Primary Responsibilities of the EDW Lead Data Architect:

• Developing ETL solution and supporting data strategy leveraging acquired subject matter expertise to identify/inform opportunities/risks.

• Developing/leading complex dashboards, scorecards, reports, data analysis

• Performing peer-reviews and providing technical support/guidance to the project team

• Leading creating/maintaining database, ETL, reporting architecture/environment, processes/procedures, coding standards, and data management/security activities

• Supporting/Standing up the enterprise data environment for disaster situations or annual disaster recovery drill

• Supporting the project manager and leadership in project planning and executing activities, including presentations, risks/issues, and status reporting

• Demonstrating deliverables to the team or the customers for approvals and gain buy-in to implement solutions or adapt to new products/services/programs

• Working with the DBAs, data modelers, and application/system admins to support maintaining the Teradata and application server hardware and software (including patches, fixes, and upgrades) and leading industry level standards or best practices.

Functional Description

Functions may include database architecture, engineering, design, optimization, security, and administration, data modeling, big data development, Extract, Transform, and Load (ETL) development, storage engineering, data warehousing, data provisioning, and other similar roles.

Responsibilities may include Platform-as-a-Service and Cloud solutions with a focus on data stores and associated ecosystems. Duties may include:

• Management of design services.

• Providing sizing and configuration assistance.

• Ensuring strict data quality.

• Performing needs assessments.

Analyzes current business practices, processes, and procedures and identifies future business opportunities for leveraging data storage and retrieval system capabilities. Manages relationships with software and hardware vendors to understand the potential architectural impact of different vendor strategies and data acquisition. May design schemas: write SQL or other data markup scripting and helps to support the development of Analytics and Applications that build on top of data. Selects, develops, and evaluates personnel to ensure the efficient operation of the function.

Required Qualifications:

• Bachelor’s degree or higher in engineering, related field, or equivalent experience

• 7 years of ETL/Informatica and enterprise data warehouse technical development

• 7 years of experience gathering requirements, exploring data, SQL/DB development

• 7 years of experience in reporting, analysis, and/or data management/governance

• 4 years of experience leading a team as a technical lead or similar capacity

• Demonstrated experience working with, and leading, high-performing remote teams and delivering to external customer

• Advanced skills in Microsoft Office (Excel, Word, PowerPoint, etc.) with strong communication skills

Preferred Qualifications:

• MBA or advanced degree

• Experience in Medicaid/Managed Care/health insurance industry

• Experience with visualization tools (Power B.I., Tableau, SAS, etc.)

• Experience using Snowflake

• Experience in scripting language experience (Python, R, SAS, T-SQL, etc.)

• Familiarity with A.I. and machine learning