Data Engineer (CIS) - Remote

Data Engineer (Corporate Information Systems Department) 25 Amica WayLincoln, RI 02865

• Promote effective data management practices and encourage better understanding of data and analytics.
• Define, develop, and execute strategies to implement and enhance an enterprise data ecosystem that supports organizational goals.
• Interact with and gather requirements from key business stakeholders, IT experts and subject-matter experts to plan and data solutions that drive business value and support CIS objectives.
• Collaborate with colleagues and data consumers on analytical solutions and models to optimize them for data quality, security and governance and deploy them to production.
• Demonstrate strong business acumen and understanding of insurance concepts.
• Prioritize, scope and manage data engineering projects.
• Discover, understand, and integrate new internal and external data sources, structures, and process pipelines.
• Lead and engage in all activities associated with design, development, implementation, and support of ETL/ELT processes.
• Implement data structures on a variety of databases and platforms, including data lakes, data warehouses, online caches and near-time systems, SQL Server, Oracle, Teradata, Redshift, MongoDB, DynamoDB, and Snowflake.
• Utilize various data modeling methodologies like relational 3rd normal form, star schema, snowflake schema, schema-on-read, data vault, etc. to design and implement data models.
• Architect, implement, optimize and maintain reliable data pipelines from source acquisition to integration and consumption while guaranteeing compliance with data governance and data security requirements.
• Use innovative and modern tools, techniques and architectures to automate the most common, repeatable and tedious data preparation and integration tasks to minimize manual and error-prone processes and improve productivity.
• Create data migration applications that manage the content of the analytics ecosystem, including data lineage, metadata management, data quality, data patterns, data curation, etc. with a strong focus on reusability.
• Partner streaming and batch processing mechanisms to provide timely but efficient to produce actionable insights and drive business value.
• Support existing data migration applications running in production.

• Bachelor's degree in data management, computer science, information systems, mathematics, data/analytics or a related field or equivalent work experience is required.
• Work experience in data management disciplines including data integration, data modeling, optimization and data quality that is commensurate with job level.
• Basic experience working with data discovery, analytics, visualization and business intelligence tools.
• Extensive experience with AWS.
• Strong experience with scripting languages such as Python, PowerShell, and Linux.
• Understanding of at least one formal programming language Java, or C.
• Basic understanding of ETL/ELT platforms such a SSIS, DataStage or Informatica.
• Thorough knowledge of relational and non-relational database theory and structured query language (SQL).
• Ability to design, build and optimize data pipelines, ETL processes, and data structures.
• Demonstrated success integrating large, heterogeneous datasets and automating repetitive data preparation tasks.
• Skilled working across multiple deployment environments including cloud, on-premises and hybrid.
• Adept applying software engineering methodologies and DevOps principles to data pipelines to improve the communication, integration, reuse and automation of data flows across the organization.
• Exceptional analytical, quantitative and logical problem-solving abilities.
• Highly creative, collaborative, and able to communicate effectively with IT and business personnel.
• Capacity to be productive when working independently or collaboratively.
• Ability to effectively manage time to handle competing high priority projects.

• Medical, dental, vision coverage, short- and long-term disability, and life insurance
• Generous leave programs, including paid parental bonding leave
• Student Loan Repayment and Tuition Reimbursement programs
• Paid Vacation - you will receive at least 10 vacation days in the first 12 months, amounts could be greater depending on the role
• Holidays - 14 paid holidays observed and 2 additional floating paid holidays provided
• Sick time - 6 days sick time at hire, 6 additional days sick time at 90 days of employment
• Generous 401k with company match and immediate vesting
• Family support benefits including back-up care
• Competitive salaries and exceptional benefits
• Fitness and wellness reimbursement
• Employee community involvement
• Strong relationships, lifelong friendships