Senior Data Engineer

State Board of Administration of Florida; Tallahassee (FL); On-site; USD 100,000 - 160,000; Full time

Job summary

State Board of Administration of Florida seeks a Senior Data Engineer to design, implement, and monitor data flows across databases, applications, and cloud services. The role focuses on data integration, ETL development, and ensuring data quality and security in support of enterprise systems.

The position requires relocation to Tallahassee and on-site work, with a strong emphasis on collaboration with internal and external partners to meet business requirements and optimize data infrastructure.

Qualifications

• Five years of related experience.
• A postsecondary degree may be used as an alternative for years of direct experience.
• Knowledge of data integration and cloud technologies is preferred.
• Strong analytical and problem solving skills.
• Ability to communicate complex data concepts to non-technical stakeholders.

Responsibilities

• Plan, execute, and manage strategic data and data store integrations across systems and cloud services.
• Design and implement data pipelines to collect, process, and transfer data to data warehouses or data lakes.
• Develop and maintain ETL processes to cleanse and transform data from diverse sources.
• Ensure data integrity and security across the data ecosystem.
• Collaborate with cross-functional teams to translate business requirements into technical solutions.
• Evaluate and select data integration tools and platforms for DI as-a-service or on-premises.

Job description

The Senior Data Engineer will work with internal and external partners and systems on electronic data integration and management projects. The position is responsible for designing, implementing, managing, and monitoring the data flow between databases, applications, and cloud services which includes troubleshooting issues, ensuring data quality, optimizing storage and compute resources, and identifying and implementing improvements. Executes data engineering work and applies technical approaches as directed by the Lead Data Engineer, ensuring alignment with established standards, methods, and architectural practices. This role is located in Tallahassee, FL and requires relocation. This role requires on-site, in-office working environment.

75% - Plan and manage the strategic integration of data and data stores into existing and new systems

• Plan, execute, and manage the strategic integration of new data and data stores into existing systems and infrastructure throughout the enterprise, including introduction of cloud services as applicable
• Ensure that data management and integration projects meet business requirements and goals, fulfill end-user requirements, and identify and resolve systems issues
• Design and implement data pipelines to collect, process and transfer data from various sources to storage systems (data warehouses, data lakes, etc.)
• Develop and maintain ETL (Extract, Transform, Load) processes to collect, cleanse and transform data from various sources (databases, flat files, APIs) inclusive of cloud
• Work to ensure a high level of data integrity and security
• Ensure that integration planning and practices are aligned with the enterprise’s overall strategic vision
• Develop standards and processes to support and facilitate integration projects and initiatives
• Revise Data Integration (DI) approaches when required, to be compatible with changing business needs and standards
• Collaborate with cross-functional teams to understand business requirements and translate them into technical solutions
• Conduct research and make recommendations on emerging DI products, languages, and standards in relation to the Cloud, BI, and big data management
• Participate in the selection, deployment, and maintenance of any DI tools, be they DI as-a-service (DIaaS) or DI on-premises, deemed appropriate for the organization
• Enhance or improve business processes via integration, or, as necessary, minimize the impact of integration on those processes

20% - Support data visualizations across organization

• Meets with stakeholders and end-users to gather requirements for data report and visualization requests
• Facilitates data provisioning in support of reporting and visualization efforts
• Validates the quality and integrity of report data
• Maintains or updates business intelligence tools, dashboards, and visualizations
• Test reports/dashboards in accordance with business and functional design following best practices for quality assurance

05% - Performs other duties as assigned

Qualifications:

Five years of related experience. A postsecondary degree may be used as an alternative for years of direct experience

Preferences:

• A bachelor's degree from an accredited college or university in business, management information systems, information technology, or a related field
• Data integration experience in investment management organizations
• Experience with Eagle Star/Pace Investment systems and BNY Mellon Data Vault
• Knowledge of cloud database management systems (e.g., Snowflake, Databricks, etc.)

Knowledge, Skills, and Abilities:

• Ability to design, build and manage data pipelines for data structures encompassing data transformation, data models, schemas, metadata and workload management
• Experience with Relational Database Environments and management techniques
• Experience in working with large, heterogeneous datasets in building and optimizing data pipelines and integrated datasets
• Proven experience in overseeing the linking of cross-functional databases between disparate business units and systems
• Experience with business and technical requirements analysis, business process modeling/mapping and methodology development, and data mapping
• Direct, hands-on experience with automated DI tools
• Knowledge of project management principles and/or substantial exposure to project-based work structures, project lifecycle models, etc
• Knowledge of system and software quality assurance best practices and methodologies
• Ability to understand end-user needs and requirements to develop right fit solutions
• Excellent oral and interpersonal communication skills
• Excellent writing and documentation skills
• Ability to communicate ideas in both technical and user-friendly language
• Ability to conduct research into application integration issues and products
• Highly self-motivated and directed, with keen attention to detail
• Experience working in a team-oriented, collaborative environment