Senior Data Engineer/Data Architect ( Snowflake ) : OneAmerica

Senior Data Engineer/Data Architect

Job title: Senior Data Engineer/Data Architect (looking for Snowflake SME)

The Data Engineer Senior/Area Data Architect will provide strategic leadership and direction for data-related projects. The role will partner closely with at least one Line of Business to maintain their data model in alignment with standards and architecture. The Data Engineer Senior will review data models, evolve and implement OneAmerica Ways around data, and design and execute on continuous improvement efforts.

• Create, test, and implement enterprise-level apps with Snowflake

• Design and implement features for identity and access management

• Create authorization frameworks for better access control

• Implement client query optimization, major security competencies with encryption

• Solve performance issues and scalability issues in the system

• Transaction management with distributed data processing algorithms

• Possess ownership right from start to finish

• Build, monitor, and optimize ETL and ELT processes with data models

• Migrate solutions from on-premises setup to cloud-based platforms

• Understand and implement the latest delivery approaches based on data architecture

• Project documentation and tracking based on understanding user requirements

• Perform data integration with third-party tools including architecting, designing, coding, and testing phases

• Manage documentation of data models, architecture, and maintenance processes

• Continually review and audit data models for enhancement

• Maintenance of ideal data pipeline based on ETL tools

• Coordination with BI experts and analysts for customized data models and integration

• Code updates, new code development, and reverse engineering

• Performance tuning, user acceptance training, application support

• Maintain confidentiality of data

• Risk assessment, management, and mitigation plans

• Regular engagement with teams for status reporting and routine activities

• Migration activities from one database to another or on-premises to cloud

• Maintain a holistic view of the scope of all data projects across a line of business looking for potential project collisions

• Provide project consultation

• Review Data Architecture overall approach at project level

• Look for opportunities to provide data reuse

• Set Data Modeling standards and processes

• Perform data model audits for standards compliance

• Maintain conceptual data models of each line of business

• Understand the complete path of data within the entire line of business

• Develop an in-depth understanding of the business data needs and the ability to align those business needs with the overall Enterprise data strategy

• Partner with the Enterprise Data Architect to influence, understand, and implement the Enterprise Data Strategy

• Help establish road maps for each line of business to achieve the Enterprise Data Strategy

• Participate in the Enterprise Data Governance Committee

• Work with Plan Organization to provide project estimation

• Evolve OneAmerica Ways for data to align to industry best practices

• Direct/Develop/Execute upon continuous improvement efforts

• Ensure reduction of tech debt is built into projects and other efforts as appropriate to keep OneAmerica current on technological advancements as they align to architectural direction

• Follow and ensure compliance to OA data and security standards

Requirements:

• 3+ years of experience in a data architect role

• 5+ years of experience data modeling data solutions including but not limited to: ODS, Data Warehouse, Data Integration Hub, OLTP/OLAP, or equivalent knowledge

• 5+ years of experience data modeling, querying, and performance tuning relational DBMS (Oracle, SQL Server, DB2)

• Experience with recent data technologies (NOSQL, Hadoop, RedShift, etc.) preferred

• Expert SQL skills and demonstrated ability to write complex SQL for purposes of analysis and translation of data needs into back-end structures

• Demonstrated experience in work estimation and management

• Leadership of focused technical teams