Job Title: Power BI Developer Work Location: 333 S Wabash Chicago, IL 60602 - Wednesday - Friday (3 days onsite per week) Duration: 5 months
Project Overview:
Replacing an existing Liquidity Limits Dashboard (LLD) from IBM’s Cognos/TM1 platform onto Microsoft’s Power BI platform.
Stand-up a self-service business intelligence reporting capability enabling business teams to create their own dashboards and make their own changes.
Qualifications (must haves):
Minimum of 10 years of IT experience
5 years plus with Power BI (comprehensive experience on most of the features and capabilities within the Power BI application)
Effective communication skills, ability to interact with partners to define requirements and provide technical training
Nice to Have (preferred):
Power Apps, Power Automate
Snowflake
Train people how to effectively create and maintain their own solutions using Power BI, Power Apps, and Power Automate
Tasks & Responsibilities:
Work with the business partners to define business requirements
Translate requirements into business Power BI design specifications (data model, formula calculations, design prototypes)
Provide consulting and guidance to other Power BI developers on solving design and development issues
Design and implement data model best practices within the Power BI solution
Design and develop BI visualizations in Power BI
Integrate various data sources using Power Query
Implement row level security - Knowledge of Power BI application security layer models
Ability to connect to Snowflake and create SQL statements to conduct analysis and validate data results
Ability to transform raw data (from Snowflake) into data visualizations and dashboards
Ability to integrate Power App into Power BI dashboards for business partner inputs
Ability to integrate Power Automate into Power BI dashboards for workflow automation
Create DAX functions and integrate M-code in Power Query
About Us: Established in 2004, SPECTRAFORCE® is one of the largest and fastest-growing diversity-owned staffing firms in the US. The growth of our company is a direct result of our global client service delivery model that is powered by our state-of-the-art A.I. proprietary talent acquisition platform, robust ISO 9001:2015/ISO 27001 certified processes, and strong and passionate client engaged teams. We have built our business by providing talent and project-based solutions, including Contingent, Permanent, and Statement of Work (SOW) services to over 140 clients in the US, Canada, Puerto Rico, Costa Rica, and India. Key industries that we service include Technology, Financial Services, Life Sciences, Healthcare, Telecom, Retail, Utilities and Transportation. SPECTRAFORCE is built on a concept of “human connection,” defined by our branding attitude of NEWJOBPHORIA®, which is the excitement of bringing joy and freedom to the work lifestyle so our people and clients can reach their highest potential. Learn more at: http://www.spectraforce.com
Benefits: SPECTRAFORCE offers ACA compliant health benefits as well as dental, vision, accident, critical illness, voluntary life, and hospital indemnity insurances to eligible employees. Additional benefits offered to eligible employees include commuter benefits, 401K plan with matching, and a referral bonus program. SPECTRAFORCE provides unpaid leave as well as paid sick leave when required by law.
Equal Opportunity Employer: SPECTRAFORCE is an equal opportunity employer and does not discriminate against any employee or applicant for employment because of race, religion, color, sex, national origin, age, sexual orientation, gender identity, genetic information, disability or veteran status, or any other category protected by applicable federal, state, or local laws. Please contact Human Resources at LOA@spectraforce.com if you require reasonable accommodation. At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position’s starting pay is: $60.00/monthly.
