Data Engineer III
Johnston, RI, United States
Factory Mutual Insurance Company
FM Global's multinational presence and capabilities allow us to provide seamless insurance solutions, services and claims response around the world.Overview
FM Global is a leading property insurer of the world's largest businesses, providing more than one-third of FORTUNE 1000-size companies with engineering-based risk management and property insurance solutions. FM Global helps clients maintain continuity in their business operations by drawing upon state-of-the-art loss-prevention engineering and research; risk management skills and support services; tailored risk transfer capabilities; and superior financial strength. To do so, we rely on a dynamic, culturally diverse group of employees, working in more than 100 countries, in a variety of challenging roles.
Responsibilities
The Data Engineer III is responsible for analysis, data modeling, data collection, data integration, and preparation of data for consumption. The Data Engineer is responsible for creating and managing data infrastructure, data pipeline design, implementation and data verification.
Along with the team, the Data Engineer is responsible for ensuring the highest standards of data quality, security and compliance. Additionally, the Data Engineer will implement methods to improve data reliability and quality, combine raw information from different sources to create consistent data sets. The Data Engineer will need to be proficient in DataOps and be able to provide technical expertise to other Data Engineers.
Data Engineers will design and build data solutions and integrations which may involve diverse data platforms, software, hardware, technologies and tools. Uses available approved technologies and recommends solution options. Incumbents may design and build application solutions and integrations which may involve diverse development platforms (including 3rd party systems), software, hardware, technologies and tools.
The Data Engineer III is the third level position in the Data Engineer job family. Those holding this position are typically assigned to work on integrated project teams for medium to large projects and be the lead for smaller projects. The Data Engineer III must also be able to work independently. The Data Engineer III must also be able to work independently.
Data Acquisition:
- Possess and continually grow knowledge of structured and unstructured data sources within each product journey (Underwriting and Risk; Client Service, Sales and Marketing; Claims; Account and Location Engineering) as well as emerging data sources (purchased data sets; external data; etc.)
- Partner with product owners, developers, solution architects, business analysts, data engineers, data analysts, data scientists and others to understand data and reporting needs
- Develop solutions using data modeling techniques and using technologies such as Analytical Platform Services (APS), Synapse, SQL Server, SSIS, cloud technologies such as Postgres, Azure Data Factory, streaming technologies such as Confluent/Kafka and others as required
- Validate solutions are accurate through detailed and disciplined testing methodologies
- Ensure tables and views are designed for data integrity, efficiency and performance, and are easy to comprehend.
Move and Store Data:
- Data flow, infrastructure pipelines, ETL/ELT, structured and unstructured data movement and storage solutions
- Design data models and data flows into and out of Data Analytics databases
- Understand and design data relationships between business and data subject areas
- Follow standards for naming conventions, code documentation and code review
Support data exploration and transformation needs:
- Conduct data cleansing and support other team members with data cleansing tasks as needed
- Conduct data profiling to identify data anomalies and resolve issues
- Execute data preparation tasks
- Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
- Build the infrastructure required for optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and Azure technologies.
Support users and production applications:
- Managing and addressing operational data issues by establishing workarounds and/or bringing in cross functional teams to solve the issues in timely manner
- Support developers, data analysts and data scientists who need to interact with data in either data warehouse
- Analyze and assess reported data quality issues, quickly identifying root cause
- Consult dba(s) and team members on configuration and maintenance of the infrastructure.
- Monitor system performance and execute opportunities for optimization
- Monitor storage capacity and reliability
- Fix productions issues quickly, with appropriate validation and deployment steps
- Provide clear and professional communication to users, management, and teammates
- Provide ad hoc data extracts and analysis to respond to tactical business needs
Participate in effective execution of team priorities:
- Ability to solve complex problems with on-time delivery
- Identify work tasks and capture them in the team backlog
- Organize known tasks, prioritize work as needed
- Ability to resolve colliding priorities and escalate as need
- Provide production support
- Network with product teams to keep abreast of database changes as well as business process changes which result in data interpretation changes
Qualifications
Prefer 4 year/Bachelor’s Degree or Master's Degree in Computer Science, Information Technology, Computer Engineering, or equivalent experience
5+ years relatable work experience
ETL/ELT design required.
SQL database and massively parallel processing (mpp) platforms required
Experience designing/building/maintaining cloud data database(s)
Knowledge of Azure Cloud applications
Familiarity with Kafka technologies
Compensation, Grade, and Job Title will be determined based on qualifications, experience, and technical skillset.
The position is eligible to participate in FM Global’s comprehensive Total Rewards program that includes an incentive plan, generous health and well-being programs, a 401(k) and pension plan, career development opportunities, tuition reimbursement, flexible work, paid time off allowances and much more.
FM Global is an Equal Opportunity Employer and is committed to attracting, developing, and retaining a diverse workforce.
#FMG
#LI-TA1
* Salary range is an estimate based on our AI, ML, Data Science Salary Index 💰
Tags: Azure Computer Science Data Analytics DataOps Data quality Data warehouse ELT Engineering ETL Kafka MPP Pipelines PostgreSQL Research Security SQL SSIS Streaming Testing Unstructured data
Perks/benefits: Career development Flex hours Flex vacation
More jobs like this
Explore more AI, ML, Data Science career opportunities
Find even more open roles in Artificial Intelligence (AI), Machine Learning (ML), Natural Language Processing (NLP), Computer Vision (CV), Data Engineering, Data Analytics, Big Data, and Data Science in general - ordered by popularity of job title or skills, toolset and products used - below.
- Open Data Manager jobs
- Open Power BI Developer jobs
- Open Principal Data Engineer jobs
- Open Marketing Data Analyst jobs
- Open Data Science Manager jobs
- Open Lead Data Analyst jobs
- Open MLOps Engineer jobs
- Open Senior Business Intelligence Analyst jobs
- Open Business Data Analyst jobs
- Open Data Analytics Engineer jobs
- Open Data Scientist II jobs
- Open Business Intelligence Developer jobs
- Open Product Data Analyst jobs
- Open Sr Data Engineer jobs
- Open Junior Data Scientist jobs
- Open Data Analyst Intern jobs
- Open Senior Data Architect jobs
- Open Sr. Data Scientist jobs
- Open Principal Data Scientist jobs
- Open Research Scientist jobs
- Open Big Data Engineer jobs
- Open Data Quality Analyst jobs
- Open Azure Data Engineer jobs
- Open Manager, Data Engineering jobs
- Open ML Engineer jobs
- Open GCP-related jobs
- Open Data quality-related jobs
- Open Java-related jobs
- Open ML models-related jobs
- Open Business Intelligence-related jobs
- Open Data management-related jobs
- Open Privacy-related jobs
- Open Data visualization-related jobs
- Open PhD-related jobs
- Open Deep Learning-related jobs
- Open NLP-related jobs
- Open Finance-related jobs
- Open PyTorch-related jobs
- Open TensorFlow-related jobs
- Open APIs-related jobs
- Open LLMs-related jobs
- Open Consulting-related jobs
- Open Generative AI-related jobs
- Open CI/CD-related jobs
- Open Snowflake-related jobs
- Open Kubernetes-related jobs
- Open Hadoop-related jobs
- Open Data governance-related jobs
- Open Databricks-related jobs
- Open Data warehouse-related jobs