Description

Index Analytics, LLC, is a rapidly growing Baltimore-based small business providing health-related consulting services to the federal government. At the center of our company culture is a commitment to instilling a dynamic and employee-friendly place to work. We place a priority on promoting a supportive and collegial team environment and enhancing staff’s experience through career development and educational opportunities.

Job Overview

The Senior Data Engineer will assist in moving the existing system solution into a more modernized platform while providing direct guidance to other members of the team. This includes acting as a go-to resource when technical challenges arise and providing leadership and coordination as part of a project team of data engineers, Cloud Architects, analysts, and BI developers to implement a Snowflake environment to ingest a wide variety of data sources to allow for data analytics.

The Senior Data Engineer determines structural, interface, and business requirements for developing and installing solutions. This includes the design of relational databases, other types of databases, and associated interfaces, used for data storage and processing. The Senior Data Engineer develops warehouse and data mart implementation strategies, data acquisition, and archive recovery. In pursuit of system and service optimization, the Senior Data Engineer may perform other duties, such as investigating new data products and technology, evaluating new data sources, and reviewing existing products and products under development for adherence to the organization's quality standards and ease of integration.

Responsibilities

• Streamline migration processes from the legacy SSIS and SQL Server ETL into Snowflake
• Re-architect and incrementally improve the performance of ETL solutions without impacting the delivery of new features requested by the client
• Assist with development efforts to modernize data ingestion patterns
• Completing development tasks such as building custom reports, developing complex queries, ETL and data warehousing, and disseminating data to stakeholders.
• Cloud engineering, CRM development and support, testing, DevOps, app support, data migrations, data loads, and scheduling jobs
• Data Modeling to support ingestion of a wide variety of CMS data sources and requirements from data analysts and other stakeholders
• Implementing business rules using SQL Server stored procedures, views, triggers, and other database objects to reduce the number of cases requiring manual analysis
• Using Python to perform file management tasks
• Optimizing existing processes to improve performance
• Work closely with product owners, the SDET team, and DevOps to ensure compliance with SDLC processes
• Collaborate with business analysts to gather requirements, develop and document business rules, create test scenarios to ensure properly working code, and communicate technical concepts for transparency

Qualifications

• US citizen, or Authorized to work and lived in the US for 3 years out of the last 5 years.
• 8 years of overall work experience, plus 7 additional years of relevant experience
• Bachelor’s Degree or equivalent OR 4 years’ relevant experience in lieu of degree
• SQL Server Integration Services (SSIS) current experience required
• DBT (data build tool) current experience required
• Strong experience with Cloud platforms such as Azure (preferred), AWS
• Experience with Azure Data Factory a plus
• Strong experience with Python or similar (2 years)
• Experience with object-oriented programming a plus
• Experience working with un/semi-structured (XML, JSON, PARQUET, video, audio, images, pdf) data
• Strong experience with SQL
• Database deployment automation experience via CI/CD tools such as CloudBees Jenkins, Azure Pipelines, Aws Code Pipeline, etc. is a plus
• Experience working within an Agile development environment or development and testing activities.
• Data modeling and database administration experience with a variety of databases
• Working knowledge of database security, audit, and RBAC controls
• Knowledge of Snowflake cloud database platform
• Hands-on experience with database performance tuning, clustering key analysis, sizing, and cost optimization
• SnowPro certification or Azure certifications are a plus
• Experience analyzing data and presenting information to stakeholders.
• Ability to obtain Public Trust level clearance.

Index Analytics provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training.