JPS Tech Solutions · 1 month ago
Data Engineer/Power BI
Warrenville, IL
Full-time
Onsite
Senior Level, Lead/Staff
10+ years expJPS Tech Solutions is seeking an experienced Data Engineer/Power BI Developer to manage and optimize their reporting infrastructure. The role involves designing and maintaining Power BI reports, ensuring data accuracy, and collaborating with stakeholders to deliver actionable insights.
Information TechnologyIT InfrastructureSoftware Engineering
Responsibilities
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
Qualification
Required
Bachelor's degree in computer science or a similar field with 10 years of experience as a data engineer or SQL developer
Minimum of 5 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
Company
JPS Tech Solutions
JPS Tech Solutions offers software engineering, cloud, mobile development, and IT infrastructure solutions.
201-500 employees
H1B Sponsorship
JPS Tech Solutions has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (7)
2024 (17)
2023 (9)
2022 (5)
Funding
Current Stage
Growth StageCompany data provided by crunchbase