About the role
Overview:
Maintains involvement and responsibility for designing, engineering, and administration of an Enterprise Data Warehouse that serves reporting and analytical needs for business. Responsible for all cloud data administration activities - including but not limited to: preparing the detailed technical design documents from functional requirement documents, designing and engineering ELT/ETL framework, setting up the DB application schemas and developing database code, unit and system testing of end-to-end integration, and release management and production support as needed.
Responsibilities:
• Works with data and analytics team to strive for greater functionality in our data systems.
• Builds the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and AWS cloud native technologies.
• Creates and maintains optimal data pipeline architecture integrating large, complex data sets that meet functional and non-functional business requirements.
• Works with project stakeholders to assist with data-related technical issues and supports data infrastructure needs.
• Identifies, designs, and implements internal process improvements such as automating manual processes, optimizing data delivery, and re-designing infrastructure for greater scalability.
• Builds analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency and other key business performance metrics.
• Works with technical and non-technical business owners to streamline and update business logic and processes as needed.
• Participates in special projects and performs other duties as assigned.
Qualifications:
Licenses and Certifications:
AWS, Azure or GCP cloud certification (Associate or Professional level) preferred
Education:
Bachelor's Degree in Computer Science, Statistics, Informatics, Information Systems or a related field required
Master's Degree preferred
Work Experience:
Minimum of two years of data replication, data engineering, and data integration and transformation, or related experience, required
Experience with Python as it relates to and support data workloads and applications (PySpark, Pandas, Data Frames, etc.) required
Experience with engineering and administration of relational SQL databases, such as SQL Server, MySQL, Postgres, and Snowflake required (Data Integration, transformation, manipulation). required
Experience in managing Role Based Access Control required
Strong proficiency to write complex SQL to perform common types of data extraction and manipulation. required
Experience with AWS cloud services such as EC2, RDS, S3 & Athena, lambda, and DynamoDB required
Experience with data pipeline and workflow management tool like Airflow required, Databricks preferred
Working knowledge in data modeling, Change Data Capture and Slowly Changing Dimensions, understating of various aspects of logical, conceptual and physical modeling of data warehouse projects preferred
Working Experience with version controlling GitHub preferred
Familiarity with healthcare datasets such as Members, Claims, Risk Adjustment preferred
Familiarity with Snowflake DB (SnowSQL, Snowscripts & Snowpipe) preferred
Prior DBA or Unix/Linux System Administrator experience required
Strong shell scripting required
Experience working with vendor technical support to address emergencies issues preferred
Pay Range:
USD $98,200.00 - USD $130,800.00 /Yr.
This page is fully interactive when JavaScript is enabled. Please enable JavaScript to apply or browse related roles.