Data Warehouse Architect III

IS Data Warehouse Architect III

Estimated Hiring Range: $ - $ Bonus Target:
Bonus - SIP Target, 5% Annual

• Create data models for advanced to complex subjects and provide guidance to junior architects.
• Create advanced ETL specifications to meet business data needs.
• Develop and maintain appropriate documentation, including current design and operation.

• Analyze data sources; partner with leaders across the organization to effectively research and recommend solutions which balance business need and risk mitigation.

• Recommend long-term data architecture goals and planning for IS and business.
• Lead and provide direction in creating and managing advanced to complex data warehouse and analytics architectures for use as reference and as input to solution development process.

• Author and serve as subject matter expert to define requirements, standards and best practices for data modeling, ETL specifications, and data warehouse development.
• Monitor and continually review existing systems to ensure they are designed to comply with established standards and to empower business operations.

• Conduct product and vendor research, and present recommendations to the lead developer and/or management.
• Establish and manage effective relations with vendors and related equipment suppliers, including installation and repair of services.

Minimum 5 years of data warehouse architecture experience. Experience should include most or all of the following:

• Dimensional modeling experience
• Metadata management
• Data quality assessment
• Performance tuning and optimization
• ETL/ELT design
• Cloud warehousing solutions
• Proficiency with SQL
• Health insurance Systems analysis and design
• Agile/Scrum methodology

Preferred Experience in health care or managed care

• Advanced knowledge of cloud data warehousing tools such as Snowflake or Redshift
• Advanced troubleshooting of system performance issues and root cause
• Advanced knowledge/skills of Microsoft SQL Server
• Advanced knowledge/skills of ETL tools, such as SSIS or Azure Data Factory
• Advanced knowledge/skills of unit and integration testing

• Strong communication skills, including listening, verbal, written, customer service, meeting facilitation, and presentations
• Ability to clearly articulate policies, instructions, goals, and objectives
• Ability to convey appropriate level of detail effectively to all levels of the organization including non-technical staff
• Ability to author policies, document risks, and propose solutions to information technology management and senior leadership
• Possess a high degree of initiative and motivation
• Ability to effectively collaborate with coworkers, staff, leaders, and executives across all departments
• Ability to work effectively with diverse individuals and groups
• Ability to learn, focus, understand, and evaluate information and determine appropriate actions
• Ability to accept direction and feedback, as well as tolerate and manage stress
• Ability to see, read, and perform repetitive finger and wrist movement for at least 6 hours/day
• Ability to hear and speak clearly for at least 3-6 hours/day

Indoor/Office Community Facilities/Security Outdoor Exposure

No

May include, but not limited to, physical and ergonomic hazards.

General office equipment and/or mobile technology

May include occasional required or optional travel outside of the workplace; the employee’s personal vehicle, local transit or other means of transportation may be used.

Work from home

• We offer a strong Total Rewards Program. This…