BI Data Analyst - Workforce Opportunity Services (WOS)

Summary

The BI Data Analyst will be responsible for designing, developing, and maintaining business intelligence solutions. Crafting and executing queries upon request for data, presenting information through reports and visualization. Your BI Data Analyst capability will focus on converting business and client reporting requirements to meet the overall needs of the organization.

Duties and Responsibilities:

• Design, publish and maintain Power BI data models with over 45 interrelated tables connected
• Implementing a data model that works seamlessly in Direct Query or Import mode
• Merging/Joining Queries (M Language) in order to filter useful data to make visuals on a high granular level
• Establishing dynamic table relations with desired Cross filtering directions.
• Implementing measures in DAX that filter out values from different tables to display calculations
• Visuals with Level Filters that maintain data consistency across interactive/dynamic pages
• Setup automated data refresh of dashboards to show the updated values from source data
• Slicer Selections and Syncing across report pages
• Translate business needs to technical specifications
• Conduct unit testing and troubleshooting
• Evaluate and improve existing BI systems
• Collaborate with teams to integrate systems
• Develop and update technical documentation
• Performs other duties as required

Professional and People skills:

• Ability to understand business context and drivers of BI projects and/or asks questions about those drivers
• Self-starter who can logically guide their own work (“what’s the next step?”), of course with some assistance and direction
• Exhibits thoroughness, completeness, and quality in work products, such as: 
  • Frequently checking own work for common-sense validity
  • Is consistent and organized in work products, documentation, and code
• Applies creative thinking to problem solving
• Ability and willingness to troubleshoot when something isn’t working
• Collaborative nature
• Must a team player
• Professional and people skills are essential
• Technical training available

Technical Skills:

• Power BI
  • Power Query concepts (query steps and M syntax, transforming data including pivoting, aggregating, and joins)
  • DAX (knows basic functions offhand, understands concept of measures and behavior of aggregate calculations in context)
  • Data model relationships including implications on visual filtering behavior and RLS
  • Nice to have: MS Fabric features (e.g., Data warehouses, lake houses, data pipelines)
• Power Automate & Power Apps
  • Can build moderately complex cloud flows (such as 2-step approvals, etc.)
  • Some experience building basic-to-moderately complex Power Apps “canvas” apps and/or “model-driven” apps
  • Nice to have: Experience with Dataverse & Power Platform “Managed Solutions”
  • Nice to have: AI builder experience
  • Nice to have: RPA and/or software testing automation experience
• SQL 
  • Knowledge of basic SQL language and concepts including: SELECTs, JOINs, GROUP BYs, Views
  • Nice to have:  Stored procedures, basic database management

Development Goals:

• We want people to join our team and work with us for the long term, and who are interested in their own professional development and trajectory
• Readily gives and receives feedback
• Willingness to learn new skills and train on new technologies or concepts

Job Type:

• Full-Time

Salary:

• $22.00/Hour (Plus Benefits)

Location:

• Dallas, TX

Benefits:

• Free Individual Health Insurance
• Free Training (Program specific)
• Paid Vacation
• Paid Company Holidays
• Education Assistance/Reimbursement (Toward first degree - Bachelors/Associates)
• Individual Mentor 
• 401k Retirement Savings
• Interest free loans (Case basis)
• Benefits valued at up to $25,000.00 annually