Job Description
As a Database Engineer, you will play a crucial role in the development and maintenance of heterogeneous database systems. Your responsibilities will include data modeling, pipeline development, custom reporting solutions, and collaborating with internal and client-facing teams to deliver high-quality data solutions.
Required Qualifications
- 23 years of experience in SQL Development
- Proficiency in dynamic SQL, experience with MS SQL Server, Azure, PostgreSQL
- Good understanding of relational data modeling concepts
- Excellent communication and collaboration abilities
- Strong analytical and problemsolving skills
- Attention to detail and commitment to quality
- Eagerness to learn new technologies and methodologies
- Bachelor's degree in computer science related STEM field
Preferred Qualifications
- Familiarity with data sets related to insurance carrier data
- Experience with data visualization tools and reporting platforms
- Experience with Python, Databricks, Snowflake, and objectoriented coding practices
- Data modeling experience
- Experience with Atlassian suite (Jira, Confluence, Bitbucket)
Key Responsibilities
Development
- Program with dynamic TSQL
- Design, implement, and maintain data stores for various data domains
- ETL, ELT, and pipeline development for data consolidation and delivery
- Consolidate data from multiple sources into normalized data models
- Conduct thorough peer reviews of new development and support processes
Analysis
- Triage, research, and resolve data issues
- Write complex queries for data retrieval and manipulation
- Optional: Familiarity with data sets related to insurance carrier data is a plus
Support
- Provide support for slowly changing dimensions, ensuring data consistency and accuracy over time
- Assist in data normalization processes to improve database efficiency and reduce redundancy
- Support data model modification and enhancement initiatives, collaborating with the software applications teams as needed
- Streamline, optimize, and document processes, creating tools for team efficiency
Location: Remote