Data Engineer at Farm Bureau Insurance of Michigan in Lansing, MI

Job description

• To build, manage, optimize, and assist in the design of data pipelines in support of information, analytics, and strategic business needs across the enterprise.
• Identify and understand source data systems and data flow between systems. Recognize changes in those systems and assess impacts on data pipelines. Adapt data pipelines to accommodate modifications triggered by source system changes or business requirements.
• Work closely with other IT or business personas while participating on projects. Demonstrate proficiency in understanding requirements and assist the team by offering expertise on data-related technical issues. Provide continuous updates on progress to project stakeholders, as well as issues or dependencies that put milestones at risk. Communicate efficiently, both written and verbally. Ask clarifying questions when needed and demonstrate teamwork and collaboration with the project team to ensure deliverables meet expectations.
• Assemble large sets of data that meet non-functional and functional business requirements and that comply to best practices and guidelines set by architects, senior and lead engineers.
• Deliver trustworthy data to ensure quality, consistency, and security practices.
• Demonstrate ability to build the required infrastructure for optimal extraction, transformation, and loading of data using current enterprise technologies. Document newly developed pipelines and keep documentation up to date. Hold frequent knowledge shares with peers to ensure cross-training.

Responsibilities

• Build, manage, optimize, and assist in the design of data pipelines.
• Identify and understand source data systems and data flow, assess impacts, and adapt pipelines.
• Work closely with IT/business personas, communicate efficiently, and provide updates.
• Assemble large data sets meeting business requirements and best practices.
• Deliver trustworthy data ensuring quality, consistency, and security.
• Build infrastructure for ETL, document pipelines, and hold knowledge shares.

Requirements

• Requirements
• Bachelor's degree in information systems, computer science, or related field required, or equivalent experience may be considered.
• Three to five years' experience working with Microsoft SQL Server, T-SQL, Visual Studio IDE, and SSIS (or equivalent ETL platforms) required.
• Current knowledge of computer hardware, operating systems, program language(s) and tools, testing techniques and tools, program specification and interpretation required.
• Working knowledge of systems design and analysis tools and techniques required.
• Willingness to pursue continuing job-related training and education in systems and insurance required.
• Working knowledge of transactional, analytical, big data structures preferred.
• Understanding database best practices and technologies such as types of compression, indexes, security, data types, and AlwaysOn preferred.
• Prior experience at an insurance company or on projects for an insurance company preferred.

Skills

Required

• Microsoft SQL Server
• T-SQL
• Visual Studio IDE
• SSIS (or equivalent ETL platforms)
• Computer hardware knowledge
• Operating systems knowledge
• Programming languages and tools
• Testing techniques and tools
• Program specification and interpretation