Summary

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