Logo of Huzzle

Data Engineering & Reporting Analyst

image

GEICO

1mo ago

  • Job
    Full-time
    Mid Level
  • Data
    IT & Cybersecurity
  • Chicago

AI generated summary

  • You need 3+ years in data analytics, SQL proficiency, Power Platform skills, data modeling knowledge, Power BI experience, cloud platform familiarity, and strong communication abilities.
  • You will design and maintain data architectures, build data pipelines, ensure data quality, optimize performance, engage with stakeholders, use agile processes, and promote collaboration while ensuring compliance.

Requirements

  • 3+ years experience in data analytics, data engineering or a similar role
  • Proficiency in SQL, data modeling, and schema design
  • Strong Proficiency in Power Platform tools (Power Apps, Power Automate, Power Query)
  • Knowledge of data modeling best practices.
  • Knowledge of Power BI development
  • Knowledge of cloud platforms
  • Understanding of data governance principles
  • Exceptional ability to synthesize large amounts of information, identify themes, trends and patterns across organizational products/activities and succinctly communicate findings
  • Highly motivated individual with the ability to learn, Methodical and diligent with a high degree of attention to detail.
  • Outstanding communication skills with a proven ability to articulate complex technical concepts effectively to diverse audiences.
  • Bachelor’s degree in Computer Science, Information Systems, Finance or related field

Responsibilities

  • Collaborate with cross-functional teams to design, enhance, and maintain data architectures
  • Build and maintain efficient data pipelines that clean, transform and aggregate data from disparate sources in a sustainable and scalable data function.
  • Implement data validation and data quality checks to ensure the accuracy and consistency of the data.
  • Analyze and optimize query performance, data storage and processing tasks to ensure high performance and costs efficiency.
  • Engage with stakeholders to understand business requirements and translate them into architectural solutions
  • Use agile software development processes to make iterative improvements to our back-end systems
  • Understand emerging capabilities and be forward thinking regarding their deployment and internal use
  • Implement CI/CD processes for analytics code enabling rapid development, testing and deployment.
  • Promote a culture of collaboration and learning across the team
  • Ensure compliance with data privacy regulations

FAQs

What is the role of the Financial Data Engineering & Reporting Analyst?

The Financial Data Engineering & Reporting Analyst is responsible for developing, architecting, and maintaining the organization's data infrastructure, ensuring seamless data integration, storage, and analytic capabilities to drive decision-making.

What qualifications are required for this position?

Candidates should have at least 3 years of experience in data analytics or a similar role, proficiency in SQL and Power Platform tools, knowledge of data modeling and cloud platforms, and a Bachelor’s degree in a relevant field.

What are the primary responsibilities of this role?

Responsibilities include collaborating with cross-functional teams to maintain data architectures, building efficient data pipelines, implementing data validation checks, analyzing query performance, engaging with stakeholders, and ensuring compliance with data privacy regulations.

Does this position require knowledge of Power BI development?

Yes, candidates should have knowledge of Power BI development as part of the requirements for the role.

What is the salary range for this position?

The annual salary range for this position is between $77,900.00 and $129,150.00, depending on various factors including experience and location.

Are there benefits associated with this position?

Yes, the position offers a range of benefits, including comprehensive medical, dental, and vision insurance, paid vacation, 401(k) plan, tuition assistance, and paid training and licensures.

What is the company's stance on equal employment opportunity?

GEICO provides a fair and equal employment opportunity for all associates and job applicants, ensuring compliance with applicable laws regardless of race, gender, disability, or other protected characteristics.

Will GEICO sponsor employment authorization for this position?

No, GEICO will not sponsor a new applicant for employment authorization for this position.

Is there a focus on data quality and governance in this role?

Yes, ensuring confidence in data quality and governance is a key aspect of the analyst's responsibilities in this role.

What tools will I need to be proficient in for this role?

Candidates should be proficient in SQL, data modeling, schema design, and Power Platform tools (Power Apps, Power Automate, Power Query), along with a knowledge of cloud platforms.

Finance
Industry
10,001+
Employees

Mission & Purpose

GEICO (Government Employees Insurance Company) provides affordable auto insurance and a variety of other coverage options, including home, renters, motorcycle, and business insurance. Their mission is to offer reliable and accessible insurance services with excellent customer support and innovative solutions. GEICO aims to deliver exceptional value by providing competitive rates, convenient services, and a commitment to meeting the diverse needs of their policyholders.