Data Engineer III​/GC​/ONSITE Cincinnati

Data Engineer III

Location:

Onsite - Cincinnati

TOP

SKILLS:

Must Have

PowerBI

SQL

Tableau

What You’ll Do

Business Intelligence Developer Job Description

Open Position(s):

Proficiency in Power BI:
Including data modeling, DAX, Power Query, and report/dashboard design.

SQL Knowledge:
For data querying and manipulation.

Data Warehousing:
Understanding principles like ETL and data modeling concepts.

JOB DESCRIPTION

GENERAL FUNCTION: A Power BI developer is responsible for designing, developing, and maintaining Business Intelligence (BI) solutions using Power BI. This includes building data models, creating reports and dashboards, and ensuring data accuracy and reliability. They also collaborate with stakeholders, translate business requirements into technical specifications, and manage the overall BI system

ESSENTIAL DUTIES AND RESPONSIBILITIES:

Data Modeling:
Designing and implementing data models within Power BI to efficiently support business requirements and enable effective analysis.

Report and Dashboard Development:
Creating interactive and visually appealing reports and dashboards using Power BI Desktop and the Power BI service.

Data Integration:
Connecting to and integrating data from various sources, including databases, cloud services, and flat files.

Data Analysis and Visualization:
Analyzing data to identify trends, patterns, and insights, and then effectively visualizing this information through charts, graphs, and other visualizations.

Performance Optimization:
Optimizing Power BI solutions for performance, ensuring efficient data retrieval and report rendering.

Collaboration and Deployment:
Collaborating with stakeholders, including business users and other IT teams, to gather requirements and deploy Power BI solutions.

Data Governance and Compliance:
Ensuring data accuracy, security, and compliance with relevant regulations and policies.

DAX Calculations:
Developing and utilizing DAX (Data Analysis Expressions) calculations to extend the functionality of Power BI and perform complex data analysis.

SQL Querying:
Utilizing SQL for data retrieval and manipulation, often in conjunction with Power BI's data transformation capabilities.

Technical Documentation:
Creating and maintaining technical documentation for Power BI solutions, including data models, report designs, and data lineage.

Troubleshooting and Support:
Providing support and troubleshooting for Power BI solutions, addressing user issues and resolving technical problems.

Staying Updated:
Keeping abreast of the latest Power BI features, updates, and best practices.

SUPERVISORY RESPONSIBLITIES:
None

MUST HAVE SKILLS

· Power BI 3-4 years

· Analytical

· SQL, 3-5 years

· Strong Communications Skills

· Able to run meetings

· Problem Solving and Critical Thinking

· Onsite in Cincinnati

NICE TO HAVE SKILLS/Experience

· Data Stage

· Dataiku

· AFS system application (AFS Level III or Vision)

MINIMUM KNOWLEDGE, SKILLS, AND ABILITIES

REQUIRED:

• Bachelor's degree in Computer Science/Information Systems or equivalent combination of education and experience.

• Strong communication skills
  - Must be able to communicate ideas both verbally and in writing to management, business and IT sponsors, and technical resources in language that is appropriate for each group.

• Excellent analytical and problem-solving skills when resolving data related issues or designing new solutions

• Experienced in SDLC and can assist in Project Management. Able to understand release management protocols and manage important tasks for implementation.

• Power BI Proficiency:
  Deep knowledge and experience with Microsoft Power BI, including:

Data Modeling:
Designing and building data models within Power BI, understanding relationships, and optimizing performance.

DAX (Data Analysis Expressions):
Writing complex DAX formulas to perform calculations, define measures, and create derived columns.

Power Query (M Language):
Using Power Query to connect to various data sources, transform, and clean data.

Report & Dashboard Design:
Creating visually appealing, user-friendly, and informative reports and dashboards that effectively communicate insights.

Data Visualization:
Choosing appropriate chart types, designing layouts, and…