Senior Analytics Engineer

EMC Insurance Companies•Des Moines, IA

21h•$100,085 - $152,122•Hybrid

About The Position

At EMC, we’re all about working together to make an impact. As part of our team, you’ll have the opportunity to grow, contribute, and gain experience that matters. We strive to be caring leaders, close partners, and responsive experts—always supporting each other to do our best work. Join us, and let’s improve lives together. This role can be performed remotely in the Des Moines, Iowa metro area with the ability to work on-site one day per week

Requirements

Bachelor’s degree, preferably in a computer science, analytics, or business related field or equivalent relevant experience
Eight years of experience in data and analytics programs or related experience
Prior experience with BI products, such as Power BI or Tableau
Experience in semantic layer and schema designs
Experience in descriptive statistics and preparing big data sets preferred
Superior knowledge of Cognos, Tableau, Power BI or similar product
Strong report architecture and reference architecture skills
Excellent Microsoft Excel skills
Strong knowledge of database platforms such as MongoDB, Hortonworks, Azure, and AWS
Superior knowledge of SQL, Python or R
Excellent knowledge of SQLdbm
Excellent ability to build processes supporting data transformation, data structures, metadata, dependency and workload management
Advanced ability to manipulate, process and extract value from large disconnected datasets
Excellent verbal and written communication skills and presentation skills
Strong analytical and problem-solving abilities
Ability to work independently and as part of a team
Excellent project coordination skills and attention to detail

Nice To Haves

Experience in descriptive statistics and preparing big data sets preferred

Responsibilities

Business Intelligence & Analytics Lifecycle: Leads highly complex and enterprise-wide business analysis activities to gather stakeholders’ reporting and dashboard requirements. Determines stakeholders’ objectives, important metrics and method of performance measurement. Develops advanced data and analytic products implementing technology best practices, guidelines and repeatable processes. Collaborates with business units and subject matter experts to capture complex analytical requirements. Maintains highly complex curated data sets and analytical solutions.
Data Modeling & Technical Design: Leads the design of scalable and efficient complex data models optimized for analytic and business intelligence tools. Develops highly complex data models that support advanced analytic products. Provides reporting architecture services on projects and keeps a reporting reference architecture up to date for the data analytic product teams. Acts as liaison during IT architectural conversations to help drive new architectural needs and align with best practices. Serves as a subject matter expert regarding technical design, analytics lifecycle and business intelligence best practices.
Development & Implementation: Writes highly complex code to transform raw data into clean, structured data sets including data cleansing, aggregation, and other necessary business rules and transformations. Translates complex business requirements into technical requirements to implement reports and dashboards created from multiple data sources. Determines and analyzes the data sources required for each report. Develops complex reporting schemas and data sets. Builds highly complex, including enterprise wide reports, dashboards and visualizations using business intelligence tools. Reviews report changes and documents to ensure proper configuration management and change controls are implemented for report development and analytic life cycle. Serves as a technical resource to other Analytics Engineering team members.
Communication & Collaboration: Promotes continuous improvement through business intelligence practices. Partners with leadership to integrate improved business intelligence in functions’ processes, workflows, and decision-making methods. Collaborates with IT leaders to increase EMC's business intelligence maturity. Communicates and explains the results of team deliverables to stakeholders. Serves as a technical expert and resource to other analytics engineers. Collaborates with Data Governance to help maintain analytic catalogues and metadata assets.
Innovation & Advanced Analytics: Identifies necessary system enhancements to deploy new products and process enhancements. Researches and investigates new technologies and methodologies to enhance advanced analytical and operational performance, focusing on regional and/or local data source exploration and supporting advanced analytics sandboxes. Works cross-functionally with Innovation to integrate Generative AI opportunities with data analytics products. Applies Machine Learning (ML) techniques and augmented analytics capabilities to automatically generate insights for end users. Analyzes current state of business intelligence maturity and identifies opportunities for improvement.

Benefits

More than 105 years of financial strength and stability
Named a five-star insurance carrier by Insurance Business America
Two-time recipient of the Best Practices Award of Excellence from the Independent Agents & Brokers of America
Multiple locations recognized as Top Workplaces based solely on team member feedback
Corporate culture that engages and empowers team members to achieve their best
Outstanding benefits with life, medical, dental, vision and prescription drug coverage
Competitive paid time off plan and a full day of volunteer time off annually
Financial incentives, including a 401(k) plan match, pension plan, OneEMC bonus plan and recognition and anniversary awards
Professional development and growth opportunities, including tuition reimbursement
Wellness initiatives to improve team member well-being and reduce health insurance costs
Flexibility to dress for your day and opportunities for alternative work arrangements