Data Engineer/Power BI

Role: Data Engineer/Power BI

Location: 27755 Diehl Road Warrenville, Illinois 60555 United States(Hybrid)

Term: 06 months contract

Job Description

Summit LLC is seeking an experienced Data Engineer/Power BI Developer to join our team and

take charge of our reporting infrastructure. If you have a passion for data visualization, a knack for

problem-solving, and a drive to support business analytics, we'd love to hear from you. The right

person will also have proven Specialization in Data Engineering, following Medallion Data

Architecture Principles, and experience building/supporting large data structures.

Job Description: You will be responsible for managing, maintaining, and optimizing our Power BI

reporting environment. You will work closely with stakeholders to understand their reporting needs,

ensure data accuracy, and deliver actionable insights through effective dashboards and reports. Your

role is crucial in ensuring that our data-driven decisions are supported by reliable and user-friendly

reports.

Responsibilities and Duties

Report Development: Design, create, and maintain Power BI reports and dashboards based on

business requirements. Understand the Data Platforms & Services strategy and

information architecture. Design and build data processing pipelines using tools and

frameworks in the Databricks/Azure ecosystem, using ADLS to automate structured and

unstructured data ingestion. Write optimized queries, views, and triggers for integration

with other applications. Maintain high standards of data quality and data integrity.

Data Management: Ensure data accuracy and integrity by managing data sources, data

models, and refresh schedules. Responsible for data engineering functions, including,

but not limited to, data extraction, transformation, loading, and integration in support

of modern cloud computing platforms like Azure and Databricks.

User Support: Provide support to end-users, including troubleshooting issues, resolving report-

related problems, and offering training and guidance on report usage.

Performance Optimization: Monitor and optimize the performance of Power BI reports

and dashboards to ensure efficient and effective data retrieval and visualization. Design,

create, and maintain Power BI reports and dashboards based on business requirements.

Ensure data accuracy and integrity by managing data sources, data models, and refresh

schedules.

Collaboration: Work with cross-functional teams to gather requirements, understand data

needs, and implement solutions that drive business insights. Work with DevOps engineers on

CI/CD processes; perform code reviews and develop processes for improving code

quality. Work with cross-functional teams to gather requirements, understand data

needs, and implement solutions that drive business insights.

Governance: Implement and enforce best practices for data governance, security, and

compliance within the Power BI environment.

Documentation: Create and maintain documentation related to report development, data

sources, and report usage for reference and training purposes. Create and maintain

documentation related to report development, data sources, and report usage for

reference and training purposes.

Qualifications and Skills

Bachelor's degree in computer science or a similar field with 5 years of experience as a

data engineer or SQL developer.

Minimum of 3 years of experience working with Power BI, with a strong portfolio of report and

dashboard development.

Proficiency in Power BI Desktop, Power BI Service, DAX, and Power Query. Excellent

understanding of T-SQL programming, ETL Processes, and Microsoft SQL Server. Strong

analytical and problem-solving skills with the ability to interpret and visualize data effectively.

Experience working with data using structured (SQL) and/or unstructured (NoSQL)

approaches.

Experience with or exposure to data visualization principles and practices, especially

with Power BI.

In-depth knowledge of Azure Data Factory, Azure Databricks, and Azure Service Bus.

Critical thinker with excellent problem-solving skills and the ability to solve end-user

problems.

A team player with good time-management skills and the ability to always maintain a

friendly demeanor.

Demonstrated ability to quickly learn new applications and technologies

Advanced working knowledge of computer software packages, including the Microsoft

Office Suite, as well as demonstrated understanding of operating systems, relational

database design and operation, query tools, reporting tools, and decision support tools

Exceptional interpersonal skills with a focus on teamwork, listening, and the ability to

build relationships beyond the IT team

Excellent verbal and written communication skills

Ability to effectively prioritize and execute tasks in a high-pressure environment

Sense of ownership and pride in your performance and its impact on the company's

success. Self-motivated with an energetic disposition.