Senior Data Engineer

Job Description

How will your role impact First Command?

The Senior Data Engineer will be responsible for design and implementation of data integration and data services across the enterprise. As part of the Enterprise Data & Analytics Team, the Senior Data Engineer will have the opportunity to shape the culture of data integration practices based on the Enterprise Data and Analytics strategy and Data Governance outcomes.

The Senior Data Engineer will use new and established automation and integration tools, Enterprise Information Management Strategy (EIMS), frameworks, critical thinking, and problem-solving skills to partner with the First Command lines of business to rationalize data needs that are critical to our data transformation which includes a migration to the Azure Cloud.

The ideal candidate is outcome-focused and has a collaborative style that fosters teamwork. They will be required to work across multiple groups and initiatives.

What will you be doing?

• Collaborate with business stakeholders to develop an understanding of their business requirements and operational processes;
• Implement and act on the recommendations, outcomes and designs from Data Governance and Enterprise Architecture;
• Develop ETL automation and integration capabilities to implement the data lifecycle, considering how data is created, transformed, stored, archived, analyzed and shared in the organization;
• Contribute to process for making data architecture decisions
• Complete data exploration and profiling by leveraging data analysis, design and presentation tools;
• Lead the design, development, and maintenance of ongoing automation, integration, services, etc. to provide the right data to the right place at the right time;
• Develop and implement automated solutions to optimize efficiency and quality of First Command enterprise data and business processes;
• Partner with Information Technology and business unit groups to develop and implement comprehensive automation and business critical data which will be leveraged for solutions that provide consistent, clean and integrated data which enables business intelligence;
• Implement methods to include unstructured and big data, such as social media, emails, pictures, videos, voice and sensor data, client surveys and feedback.

What skills/qualifications do you need?

Education

• BS preferred; MBA or MS or equivalent a plus.

Knowledge, Skills and Abilities

• 7+ years of applied experience in data integration, ETL, and data management or comparable positions that handle large/complex data sets, developing automation, and fostering business partner relationships
• Excellent written communication and presentation skills
• Expert in SQL with knowledge of T-SQL
• Expert in ETL tools such as SSIS, Azure Data Factory and Informatica
• Ability to quickly adapt to changing priorities and generating innovative solutions
• Expert in transforming manual processes to industry standards and automation
• Proficient in understanding of data mapping and lineage strategies
• Proficient in understanding in conceptual, logical and physical data design
• Proficient in understanding of data management practices, data architecture principles, and data governance process

• Financial services industry experience or other highly regulated industry experience a plus
• Certifications related to Data Integration a plus
• Applied experience in Agile, SAFe, Scrum or Lean Six Sigma (Preferred)
• Familiarity with analytics solutions and data science capabilities (Preferred)
• Familiarity with object-oriented programming and the software development process (Preferred)
• Familiarity with data science and analytics tools such as SPSS, SAS, Tableau, PowerBI (Preferred)

#LI-NC1