Logo for EMC Insurance Companies

Senior Analytics Engineer

Roles & Responsibilities

  • Bachelor's degree in computer science, analytics, or business-related field, or equivalent relevant experience.
  • Eight years of experience in data and analytics programs or related field.
  • Experience with BI tools such as Power BI or Tableau and strong reporting architecture/semantic layer design.
  • Proficiency in SQL and Python or R, with experience in database platforms (e.g., MongoDB, Azure, AWS) and data modeling.

Requirements:

  • Lead enterprise-wide business analysis to gather stakeholders' reporting and dashboard requirements, define objectives and metrics, and develop advanced data and analytic products with repeatable processes.
  • Design scalable, efficient data models optimized for analytic and BI tools; provide reporting architecture services and maintain up-to-date reference architecture; liaison with IT for architectural alignment.
  • Implement data transformations and develop complex, enterprise-wide reports and dashboards, translating business requirements into technical specifications and ensuring proper configuration management and change controls.
  • Promote continuous BI improvement, collaborate with leadership and IT to raise BI maturity, assist Data Governance with metadata/catalog maintenance, and explore AI/ML opportunities to generate insights.

Job description

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**

Essential Functions:

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.

Education & Experience:

  • 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

Knowledge, Skills & Abilities:

  • 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

The hiring salary range for this position will vary based on geographic location, falling within either of the following:

$100,085 - $138,285 or $110,624 - $152,122

A hiring range represents a subset of the full salary range. The actual salary will depend on several factors, including relevant education, skills, and experience of an applicant, geographic location, and business needs.

 

 

For information relating to the benefits EMC Team Members receive as part of a comprehensive rewards package, please visit www.emcins.com/careers.

Our employment practices are in accordance with the laws that prohibit discrimination due to race, color, creed, sex, sexual orientation, gender identity, genetic information, religion, age, national origin or ancestry, physical or mental disability, medical condition, veteran status, active military status, citizenship status, marital status or any other consideration made unlawful by federal, state, or local laws.

All of our locations are tobacco free including in company vehicles.

Related jobs

Other jobs at EMC Insurance Companies

We help you get seen. Not ignored.

We help you get seen faster — by the right people.

🚀

Auto-Apply

We apply for you — automatically and instantly.

Save time, skip forms, and stay on top of every opportunity. Because you can't get seen if you're not in the race.

AI Match Feedback

Know your real match before you apply.

Get a detailed AI assessment of your profile against each job posting. Because getting seen starts with passing the filters.

Upgrade to Premium. Apply smarter and get noticed.

Upgrade to Premium

Join thousands of professionals who got noticed and hired faster.