Principal Data Engineer

Job Description

How will your role impact First Command?

The Principal Data Engineer is responsible for design and implementation of data integration and data services across the enterprise. The Principal Data Engineer is a pioneer in our modern data platform implementation. As part of the Enterprise Data & Analytics Team, the Principal 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 Principal Data Engineer will use new and established automation and integration tools, with Cloud-First design patterns, 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 the migration to our modern data architecture within 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
• Lead the Implementation 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
• Provide mentorship to team members and citizen data developers
• 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.

Required Qualifications

• 9+ 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 with the most recent 3-5 years in cloud data engineering
• Expert in all varieties of SQL with emphasis on T-SQL, PL/SQL, Spark SQL
• Expert in ETL tools such as SSIS, Azure Data Factory, Data Bricks, Python/PySpark
• Excellent written communication and presentation skills
• 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
• Certifications within Azure (Azure Fundamentals, Azure Data Engineer)
• Familiarity with data science and analytics tools such as SPSS, SAS, Tableau, PowerBI
• Familiarity with object-oriented programming and the software development process

Preferred Qualifications

• Financial services industry experience or other highly regulated industry experience
• Certifications related to Data Integration
• Additional Cloud Data certifications (DataBricks, Delta Lake, Spark)
• Experience and Certifications within Salesforce
• Applied experience in Agile, SAFe, Scrum or Lean Six Sigma
• Familiarity with analytics solutions and data science capabilities

#LI-NC1