Data Engineer/Power BI

Position Type: Contract to Perm
Location: Warrenville, IL (Onsite)

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.