Data Architect

GEHA (Government Employees Health Association, Inc., pronounced G.E.H.A.) is a nonprofit member association that provides medical and dental benefits to more than two million federal employees and retirees, military retirees and their families. We celebrate diversity and are committed to creating an inclusive environment for all employees.

GEHA has one mission: To empower federal workers to be healthy and well.

Offering one of the largest medical and dental benefit provider networks available to federal employees in the United States, GEHA empowers health and wellness by meeting its members where they are, when they need care. We serve our members with products they value and a personalized customer experience, sustained by a nimble and efficient organization.

• Drive architecture first mindset with a heavy focus on Data Warehouse and driving Kimball modeling methodologies and business driven domains.
• Establishes policies and procedures for data architecture and movement to be implemented by the Data & Analytics organization, including policies for standardizing data systems and data software across the enterprise.
• Acts as technical mentor for members of the Data & Analytics team, providing input and feedback to others.
• Review Technical Design Documentation and participate in peer review cycles with technical & non-technical counterparts.
• Establishes and maintains documentation of programs, user guides, policies and procedures, particularly in support of the acceptance of solutions as credible to non-technical users of information.
• Collaborate with Business stakeholders, Data Analysts, Developers and Data Scientists in the development and integration of data, insights and solutions.
• Provides oversight, input, design and implementation support for new solution development, including but not limited to new data platforms, data management, primary & secondary storage environments, and business intelligence solutions.
• Evaluates existing applications and systems. Recommend improvements or modifications.
• Responsible for creating and maintaining the catalog of architectural diagrams used by the team.
• Support Data Governance efforts, including guidance, stewardship, and frameworks for managing data across the organization and identify opportunities for data reuse, migration, or retirement.
• Recommends training on new technologies to keep the GEHA development staff cutting edge.
• Encourage and support a self-service architecture to promote a trusted source of distributed data and analytic capabilities and insights, leading the enterprise in its goal to be an insight-driven organization.

Requirements

• Bachelor's degree in computer information services or a related field.
• 8-10 years of experience with enterprise data management, including hybrid and cloud environments.
• 5 years' experience with data modeling (Conceptual, logical and physical) for a Data Warehouse.
• Strong experience leading technical data strategy, design, development, implementation and maintenance of large-scale cloud enterprise data warehouse platforms such as Snowflake, Azure Synapse Analytics, Databricks etc. on one of the cloud platforms like Azure, AWS or Google Cloud.
• Experience in architecting solutions, data engineering, integration and ETL/ELT workflows using tools and platforms such as Azure Data Factory, Azure Synapse Analytics, Databricks, PySpark, Apache Spark etc. with focus on integrating to diverse data sources.
• Proficiency with the SQL Server core data engine, SSIS, SSRS, PowerBI, Visual Studio, .NET, Power shell (and related scripting languages), Snowflake tools and processes, MS Office Products and source management tools (e.g., Azure DevOps, TFS, Git).
• Excellent working knowledge of relational databases such as MS SQL Server or Azure SQL Database/ Snowflake Data warehouses including but not limited to indexing best practices and modeling.
• Experience designing and architecting Master Data Management (MDM) solutions using platform such as Profisee, Informatica Intelligent Data Management Cloud etc.
• Experience in migrating data and processes from On-Prem to Cloud platforms.
• Strong experience implementing platforms leveraging Cloud data lake and Cloud Data Warehouse (in Snowflake) architecture.
• Experience observing change management and code promotion through non-production environments.
• Experience loading data stores ensuring processes are configurable, resilient, and performant.
• Ability to develop data translation objects and data processing flow using modern tools and adapt to new ones as they become available.
• Proven ability to work independently to coordinate and solve highly complex technical data transformation issues. Ability to effectively communicate with customers to clarify data format requirements and negotiate compromise.
• Requires effective communication and presentation skills. Demonstrates the ability to work and design for multiple projects.
• Maintains knowledge of current and upcoming technologies.
• Mentor junior developers, conduct code reviews and act as a resource to others to resolve complex problems.
• Works under minimal supervision with wide latitude for independent judgment.

Preferred

• Relevant certification in data architecture data engineering on any one of the cloud platforms such as Azure, AWS or Google Cloud.
• 3 years of demonstrated experience in the Healthcare industry, with preference for experience with Healthcare Payers.
• Experience designing and implementing scalable, high-performance data architectures for AI/ML applications.

Work-at-home requirements

• Must have the ability to provide a non-cellular High Speed Internet Service such as Fiber, DSL, or cable Modems for a home office.
• A minimum standard speed for optimal performance of 30x5 (30mpbs download x 5mpbs upload) is required.
• Latency (ping) response time lower than 80 ms
• Hotspots, satellite and wireless internet service is NOT allowed for this role.
• A dedicated space lacking ongoing interruptions to protect member PHI / HIPAA information

How we value you

• Competitive pay/salary ranges
• Incentive plan
• Health/Vision/Dental benefits effective day one
• 401(k) retirement plan: company match - dollar for dollar up to 4% employee contribution (pretax or Roth options) plus a 6% annual company contribution
• Robust employee well-being program
• Paid Time Off
• Personal Community Enrichment Time
• Company-provided Basic Life and AD&D
• Company-provided Short-Term & Long-Term Disability
• Tuition Assistance Program

Please note that the salary information is a general guideline only. GEHA considers factors such as (but not limited to) scope and responsibilities of the position, candidate's work experience, education/training, key skills, internal peer equity, as well as, market and business considerations when extending an offer.

GEHA is an Equal Opportunity Employer, which means we will not discriminate against any individual based on sex, race, color, national origin, disability, religion, age, military status, genetic information, veteran status, pregnancy, marital status, gender identity, and sexual orientation, as well as all other characteristics and qualities protected by federal, state, or local law. GEHA will not discriminate against employees or applicants because they have inquired about, discussed, or disclosed their compensation or the compensation of another employee or applicant. We are committed to creating an inclusive environment for all employees. Our diversity drives innovation deepens connections and strengthens our organization.

GEHA is headquartered in Lee's Summit, Missouri, in the Kansas City area. We recognize the importance of balance and flexibility and offer hybrid and work-from-home options for many of our roles.