Staff Data Engineer

$120,000 - $125,000/Yr

The Judge Group - Columbus, OH

Full-time - Mid Level

Columbus, OH

Administrative and Support Services

About the position

The Staff Data Engineer is responsible for designing, building, and implementing critical components of the enterprise data platform to meet the strategic data and analytics needs of the company. This role requires expertise in data management and cloud data engineering, focusing on developing a cross-business unit data tier to enhance products and deliver insights. The position involves collaboration with data analysts and engineers, influencing data integration practices, and mentoring other data professionals.

Responsibilities

• Implement data engineering solutions that satisfy the full data lifecycle including efficient technical hygiene and the use of Azure DevOps for the tactical implementation of our data strategy and roadmap as it relates to data marts and analytics systems.
• Develop ETL and data pipeline capabilities considering how data is created, transformed, maintained, stored, archived, analyzed, and shared across the organization and our partners.
• Implement built-in quality and compliance-by-design in all data solutions.
• Implement methods to include unstructured data and big data.
• Lead the implementation of outcomes, recommendations, and designs from Data Governance and Enterprise Architecture.
• Actively participate in making data architecture decisions.
• Collaborate with product owners and business stakeholders to gain a working understanding of business requirements and operational processes.
• Provide technical mentorship to team members and other data professionals.
• Perform data exploration and data profiling with tools as needed.

Requirements

• 5+ years' experience with data engineering specifically in Extract, Transform and Load (ETL) concepts and processes, enterprise data warehouse capabilities, database principles, and other related tools and technologies; preferably strong to expert in SSIS and Azure Data Factory.
• 3+ years' experience designing, implementing, and supporting cloud data solutions; Azure Data Lake, Azure Data Factory, Azure Synapse, and Azure DevOps CI/CD experience must.
• Experience in programming languages such as Python, Powershell, etc.
• Expert level experience with at least one RDBMS and query language such as T-SQL, PL/SQL, Spark SQL.
• Bachelor's degree in engineering or related field or equivalent experience in data management and/or data analytics.
• Experience in conceptual, logical, and physical data design.
• Excellent communication skills both verbal and written.

Nice-to-haves

• Experience in Agile, SAFe, and/or Scrum.
• Experience integrating with data quality, data catalog and data lineage tools such as Informatica Intelligent Data Management Cloud (IDMC) is a plus.
• Certifications within Azure such as Azure Fundamentals, Azure Data Engineer, Azure Data Scientist, and/or Azure DevOps Engineer.
• Banking or financial services industry experience or other highly regulated industry experience.

Benefits

• Competitive salary
• Opportunities for professional development
• Mentorship programs
• Collaborative work environment