Data Engineer

MMG INSURANCE COMPANY

Job Description

Job Title:                   Data Engineer

Department:           Data, Analytics, and Insights

Reports To:              Data, Analytics, and Insights Director

FLSA Status:            Exempt 

SUMMARY

Facilitates the utilization of enterprise data for helping decision makers. Develops pipelines to transform raw data into reliable and usable information for analysis. Incorporates best practices for data transformation, utilizing automated delivery. Ensures data quality standards are maintained throughout the transformation process. Works with the project team to ensure data deliverables are both timely and meet specifications.  

ESSENTIAL DUTIES AND RESPONSIBILITIES

·       Plans and creates data pipelines supporting business intelligence.

·       Builds data migration scripts and procedures using tools such as SSIS.

·       Participates in data lake architecture design and decision making.

·       Understands and utilizes Microsoft Azure cloud platform and tools.

·       Collaborates on data model design.

·       Maintains technical documentation of data systems including but not limited to the MMG Data Catalog

·       Facilitates importing of third-party data into data lake.

·       Investigates exceptions in data migrations.

·       Supports and performs data masking activities using tools such as Delphix.

·       Collaborates on sub-production environment data refresh strategy.

·       Executes sub-production environment data refreshes. 

·       Builds validations and checks for examining and maintaining data quality.

·       Creates queries to support data delivery including reports, dashboards and other visualizations.

·       Evaluates data migration approaches and technologies and recommends process improvements as needed.

·       Work with data and analytics experts to strive for greater functionality in our data systems.

·       Stays current with business operations and business intelligence technologies

·       Develops scripts for data patches as needed.

·       Maintains good working relationships and strong communication with other members of the team.

·       Travels as required to perform the duties and responsibilities of the position and to fulfill educational requirements. (May include overnight stays.)

·       Other duties may be assigned.

OTHER SKILLS AND ABILITIES

·       Demonstrates leadership by exhibiting confidence in self and others; Inspires and motivates others to perform well; effectively influences actions and opinions of others; Accepts feedback from others; Gives appropriate recognition to others. Possesses above-average telephone skills.

·       Possesses above-average interpersonal and relationship skills.

·       Customer Service – Manages difficult or emotional customer situations; Responds promptly to customer needs.

·       Solicits customer feedback to improve service; Responds to request for service and assistance; Meets commitments.

·       Professionalism – Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration regardless of their status or position; Accepts responsibility for own actions; Follows through on commitments.

·       Demonstrates the ability to consistently maintain a positive attitude.

·       Works cooperatively and productively with employees.

·       Is self-motivated with strong organizational skills.

·       Demonstrates the ability to multi-task effectively and efficiently.

EDUCATION and/or EXPERIENCE

Bachelor's degree in a field with an emphasis on analytical skills, such as mathematics, engineering, computer science or a Bachelor’s degree in business administration with an ability to demonstrate SQL skills. 2-4 experience in the same or related role.