Cedar Rapids, IA, USA
icrunchdata Network
Job ID 2019-2012 of Openings 1 Job Locations US-IA-Cedar Rapids | US-CA-Rocklin | US-CO-Denver | US-NJ-Pennington | US-TX-Webster Posted Date 2019-05-06 Category Enterprise Analytics Travel None Company Car Provided No Overview UFG offers you an award-winning workplace and a trustworthy, financially stable company. While we’ve always known our commitment to employees and financial stewardship, it is good to have others recognize our dedicated efforts. We’ve been named an Iowa Top Workplace by the Des Moines Register for four consecutive years, and included on Forbes’ “America’s Most Trustworthy Financial Companies” every year since 2014. Additionally, UFG is a super-regional property and casualty insurer rated “A” (Excellent) by A.M. Best Company. The Senior Data Engineer will facilitate the development of data management solutions in support of UFG’s strategic plan. This position will work closely with business units throughout the organization to develop and implement data strategies that support the democratization, integration, and standardization of data at an enterprise level, ensuring consistency of business definitions and data quality. This position requires strong technical and communication skills, as well as proven experience in data management, information management, and the insurance industry in general. Responsibilities Facilitate the standardization of business definitions and maintain artifacts in support of the sematic data layer Maintain data dictionary by revising and entering definitions Develop and implement databases, data collection systems, data analytics, and other strategies that optimize statistical efficiency and quality Contribute to the design, construction, installation, testing and maintenance of highly scalable data warehouse solutions Manage and design the reporting environment, including data sources, security, and metadata Integrate new data management technologies and software engineering tools into existing structures Employ a variety of languages and tools (e.g. scripting languages) to marry systems together Recommend ways to improve data reliability, efficiency and quality Collaborate with data architects, modelers and IT team members on project goals Maintain technical knowledge by attending educational workshops, reviewing publications, establishing personal networks, and participating in technical societies Evolving our process and architecture by implementing new technologies, Knowledge of Cloud Technologies is an added advantage Provide technical leadership and coach junior team members as required and be able to lead small projects/teams efforts towards successful completion Qualifications Bachelor’s degree in Computer Science 10 years of work experience as a data engineer or in related field Ability to analyze existing tools and databases, and provide recommendations Ability to translate business requirements into non-technical, lay terms 5 years of strong experience with SQL and be able to write efficient code 5 years programming experience with any ETL tool (e.g. SSIS) Experience in methodologies and processes for managing large scale databases on premise as well as cloud solutions Demonstrated experience in handling large datasets, structured and semi-structured data formats Understanding of star/snowflake schemas as general data warehousing methodologies (i.e. Kimball) Understanding of metadata standards Strong analytical thinking and verbal communication skills Ability to deliver incremental value via an Agile Development Methodology PI114452270 [...]