Data and Reporting Engineer

PM Consulting

United States

Remote

USD 100,000 - 140,000

Full time

4 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

PM Consulting seeks an experienced Data and Reporting Engineer to design reliable data solutions, reporting tools, dashboards, and automation that collect from multiple sources with accuracy, security, and accessibility in mind.

You will work with onshore stakeholders to translate requirements into ETL pipelines, data models, and dashboards using Tableau, Power BI, SAS, and SQL, while upholding data governance and Agile practices.

Qualifications

  • Bachelor’s degree in Computer Science, Information Technology, or equivalent experience.
  • At least seven years using SAS Base/Enterprise Guide, SQL, Excel, Tableau and Power BI.
  • Automation initiatives with measurable business benefits.
  • At least one year in financial services, preferably insurance.
  • Experience in a consulting or shared-services environment is preferred.

Responsibilities

  • Extract data from databases, APIs, and flat files; ensure accuracy and consistency.
  • Develop, maintain and improve ETL processes and data models.
  • Design and maintain data warehouses or data lakes for storage and retrieval.
  • Create complex reports, dashboards, and analytics across the function.
  • Consolidate reporting outputs and improve reporting processes.
  • Implement data governance, validation controls, and data quality checks.
  • Lead projects with onshore stakeholders using Agile methodologies.

Skills

Data modeling
SQL
Analytics
Problem solving
Agile

Education

Bachelor’s degree in CS/IT or related

Tools

SAS Base
SAS Enterprise Guide
Apache NiFi
Apache Spark
Talend
Snowflake
Amazon Redshift
Google BigQuery
Tableau
Power BI
QlikView
Python
Java
Scala

Job description

Role Overview We are seeking an experienced Data and Reporting Engineer to develop reliable data solutions, reporting tools, dashboards, and automation initiatives. The role is responsible for collecting, transforming, storing, and managing data from multiple sources while ensuring accuracy, consistency, security, and accessibility. You will produce complex reports and analytics, consolidate reporting outputs across the function, and deliver project-based reporting solutions. You will also work directly with onshore stakeholders and assigned business units to understand requirements and manage reporting projects.

Key Responsibilities
Data Engineering and Management
  • Extract data from databases, APIs, flat files, and other relevant sources.
  • Clean, transform, and prepare data to maintain accuracy and consistency.
  • Develop, maintain, and improve ETL processes.
  • Manage large and complex datasets to support reporting and analytics requirements.
  • Design and maintain data warehouses or data lakes for efficient data storage and retrieval.
  • Develop appropriate data models and database schemas.
  • Administer and optimize databases for performance, scalability, and reliability.
  • Maintain appropriate data security and access controls.
Reporting and Visualization
  • Design and produce complex reports, analytical outputs, and interactive dashboards.
  • Consolidate reports and improve reporting processes across the function.
  • Develop project-based reporting tools using platforms such as Tableau, Power BI, or comparable solutions.
  • Partner with business analysts and stakeholders to gather, clarify, and translate reporting requirements into practical solutions.
  • Create and maintain effective report templates and reporting designs.
Data Quality and Governance
  • Develop and implement validation controls and data quality checks.
  • Investigate stakeholder data queries and perform root-cause analysis.
  • Identify and resolve data integrity issues.
  • Support the development and implementation of data governance procedures.
  • Review reports produced by the team to ensure compliance with documented procedures and quality standards.
Automation and Performance
  • Build automated solutions for data processing, reporting, and repetitive operational activities.
  • Enhance data pipelines and reporting platforms to accommodate increasing data volumes.
  • Monitor system and pipeline performance and troubleshoot operational issues.
  • Optimize database queries and reporting processes.
  • Establish alerts for system failures, data anomalies, or processing issues.
Project and Stakeholder Management
  • Lead reporting projects and manage requirements from onshore stakeholders and assigned business units.
  • Serve as the primary point of contact for designated reporting initiatives.
  • Apply Agile delivery approaches, including Scrum, Kanban, and Lean, across reporting projects.
  • Communicate project requirements, progress, risks, and outcomes clearly to relevant stakeholders.
Documentation and Continuous Improvement
  • Maintain accurate documentation for data pipelines, models, reports, and reporting procedures.
  • Share technical knowledge, standards, and best practices with team members and stakeholders.
  • Stay informed about emerging data engineering technologies and reporting practices.
  • Continuously strengthen expertise in SQL, data modeling, automation, and visualization tools.
Qualifications
  • Bachelor’s degree in Computer Science, Information Technology, or a related discipline, or equivalent professional experience.
  • At least seven years of relevant experience using SAS Base, SAS Enterprise Guide, SQL, Excel, Tableau, and Power BI.
  • Demonstrated involvement in multiple automation initiatives that produced measurable business benefits.
  • At least one year of experience in the financial services industry, preferably within insurance.
  • Experience working in a consulting or shared-services environment is preferred.
Technical Knowledge and Skills
  • Strong proficiency in data modeling, SQL, and database management platforms such as SQL Server, Oracle, or PostgreSQL.
  • Experience with ETL technologies and processes using tools such as SAS Base, SAS Enterprise Guide, Apache NiFi, Apache Spark, or Talend.
  • Knowledge of data warehousing concepts and platforms such as Snowflake, Amazon Redshift, or Google BigQuery.
  • Experience using reporting and visualization tools such as Tableau, Power BI, or QlikView.
  • Programming capability in Python, Java, or Scala for data processing and automation.
  • Strong mathematical, statistical, analytical, and problem-solving abilities.
  • Understanding of data governance, data integrity, and information-security principles.
  • Working knowledge of Agile methodologies, including Scrum, Kanban, and Lean.
  • Fundamental understanding of data analysis, extraction, and management techniques for insurance portfolios.
  • General knowledge of insurance operations and relevant market conditions is preferred.
  • Ability to create and design effective reporting templates.
  • Excellent communication and stakeholder-management skills.
  • Ability to work effectively with cross-functional and geographically distributed teams.
  • Adaptability to evolving data technologies, reporting tools, and industry practices.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Manager Data Engineer
Manager Data Engineer

TechDigital Group • Detroit (MI)

On-site
USD 140,000 - 180,000
Senior Data Analyst
Senior Data Analyst

TechDigital Group • Princeton (NJ)

On-site
USD 70,000 - 90,000
Senior Data Platform Engineer - Cloud, Data Vault & AI
Senior Data Platform Engineer - Cloud, Data Vault & AI

TechDigital Group • Detroit (MI)

On-site
USD 150,000 - 190,000
Sr. Data Engineer
Sr. Data Engineer

ProArch • United States

Remote
USD 140,000 - 190,000
Enterprise Data Engineering Manager for AI & Cloud
Enterprise Data Engineering Manager for AI & Cloud

TechDigital Group • Detroit (MI)

On-site
USD 140,000 - 180,000
Sr. Data Engineer
Sr. Data Engineer

ProArch • Atlanta (GA)

On-site
USD 120,000 - 180,000
Principal Data Engineer
Principal Data Engineer

TechDigital Group • Detroit (MI)

On-site
USD 150,000 - 190,000
Data Engineering Lead: Snowflake, ADF & Databricks
Data Engineering Lead: Snowflake, ADF & Databricks

TechDigital Group • Dallas (TX)

On-site
USD 90,000 - 150,000
Senior Data Engineer (Contract To Hire)
Senior Data Engineer (Contract To Hire)

Tier4Group • United States

On-site
USD 120,000 - 180,000
Business Intelligence Developer
Business Intelligence Developer

Communication Service for the Deaf • United States

Remote
USD 90,000 - 130,000