Data Engineer

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. Requirements Required 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. Preferred 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. Farm Bureau offers a full benefit package including medical, dental, vision, and 401K. Note: If a candidate is not selected, an Associate Data Engineer position may be considered on the level of experience and qualifications. Work Type Hybrid Standard Hours 8:00am-4:30pm Position Type Full-time 90,766 Location(s) Lansing , Michigan 48917 The Michigan Farm Bureau Family of Companies is an equal opportunity employer. The Company will not discriminate against applicants or employees on the basis of race, color, religion, national origin, age, sex, pregnancy (including childbirth or related medical condition), disability, genetic information, sexual orientation, gender identity, military status, citizenship, or any other class protected by applicable law. In accordance with Michigan's Persons with Disabilities Civil Rights Act, the companies listed above advise you as follows: If you believe that any of the above-listed companies has failed to accommodate you as a disabled individual, you may allege a violation against that company for failing to so accommodate you, but only if you have notified that company in writing of your need for accommodation within 182 days after the date on which you knew, or reasonably should have known, that an accommodation was needed by you to perform the job which you hold or seek. #J-18808-Ljbffr