- Design and maintain a scalable and secure Azure data warehouse.
- Build data pipelines: Create and manage data integration processes, including data extraction, transformation, and loading (ETL) from various sources into the data warehouse.
- Develop and implement data management strategies to ensure data quality, consistency, and accuracy.
- Collaborate with cross-functional teams, including to identify data requirements and develop data models.
- Develop, adhere, and enforce data governance policies and procedures to ensure compliance.
- Monitor data quality and develop response mechanisms to address problems.
- Collaborate with IT teams to ensure the availability, reliability, and performance of data systems and infrastructure.
- Develop documentation related to data management processes, procedures, and data dictionaries.
- Stay up to date with industry trends and advancements in data management technologies and techniques.
- Maintain the current state legacy Microsoft environment and processing, which includes troubleshooting production issues and implementing tactical enhancements where needed.
- As needed, collaborate with external contractors to enhance data solutions. Coordinate their work, provide guidance, and ensure alignment with project goals.
What Youll Bring
- Bachelor's or Master's degree in Computer Science, Information Systems, or a related field.
- Proven experience working as Data Engineer or similar role, preferably in the insurance or financial industry.
- Strong knowledge of data management principles, data quality assurance, and data governance practices.
- Proficiency in data warehousing concepts, and ETL processes.
- Experience with data integration tools and technologies (e.g., SQL, Python, ETL frameworks).
- Solid understanding of regulatory requirements related to data privacy and security (e.g., GDPR, HIPAA).
- Excellent problem-solving and analytical skills, with the ability to analyze complex data sets.
- Strong communication and interpersonal skills to collaborate with cross-functional teams and communicate complex ideas effectively.
- Proficiency in Microsoft services in Azure, Data Factory, Data Lake/warehouse storage.
- Ability to design and implement data integration solutions using Azure Data Factory.
- Expertise in designing and optimizing data warehousing solutions Azure SQL Data Warehouse.
- Familiarity with Azure Data Lake Storage and data processing using Azure Data Lake Analytics.
- Data Governance and Security: Understanding of data governance principles and compliance requirements within Azure, including access control and data privacy.
- Monitoring and Troubleshooting: Skills in monitoring, optimizing, and troubleshooting data pipelines within Azure Data Factory.
- Proficiency in scripting languages like PowerShell or Python for automation tasks in Azure.
- Strong communication and collaboration skills to work effectively with cross-functional teams.
- Proactive in staying updated with the latest Azure data services and advancements.
- Competitive compensation to reward you for your hard work every day.
- Progressive Paid-Time Off program for you to enjoy time out of the office, including time off for volunteering and life events.
- Group Medical, Dental, Vision and Life insurance to encourage a healthy lifestyle.
- Pretax Health and Dependent Care Spending Accounts to ease taxes on spending.
- Discounts in retail and entertainment.