Talent.com
Senior Power BI Engineer - Kansas City, MO

Senior Power BI Engineer - Kansas City, MO

LEVERAGEncy, LLC (dba Amplified Sourcing)Grandview, MO, US
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.job_card.permanent
job_description.job_card.job_description

Job Description

Job Description

OVERVIEW :

  • ROLE : Power BI Engineer (Administration exposure a plus)
  • ROLE TYPE : Direct Hire
  • COMPENSATION : The end client has indicated a budget of approximately $120,000 for a base salary, depending on experience (potentially higher, but requiring sign-off from the executive team).
  • WORK LOCATION : This position is 100% remote, anywhere in Missouri. Occasional travel may be required for internal meetings, but travel costs will be covered for such meetings.
  • WORK AUTHORIZATION : The client, by default, cannot sponsor visa candidates for this role; therefore, work authorizations must be held by U.S. citizens, Permanent Residents (Green Card holders), or Visas not based on employer sponsorship (such as visas sponsored by a spouse or relative).
  • NUMBER OF POSITIONS :
  • START : Ideally, mid-to-late October.
  • JOB ID : CH- 250924

CURRENT SITUATION :

The client's current data environment is primarily based on SQL Server and largely on-prem. Their existing data warehouse integrates data from multiple EHRs and internal systems into a centralized SQL Server environment; however, it is not cloud-native and only supports data up to the previous day, which limits real-time reporting capabilities. Much of the warehouse was built in a report-specific, ad hoc manner, leading to inconsistent structures, limited reuse, and inefficient joins. There is no established star schema, operational data store (ODS), or layered architecture to support scalability or best practices in business intelligence (BI).

This new hire will join an existing team focused on modernizing the company's reporting using Power BI. Here are some of the core tasks slated for the team in the next year or so :

  • Participate in the Audit and rationalization of 700+ legacy reports
  • Participate in the build-out of baseline executive and operational dashboards
  • Participate in the transition of ownership of reporting from a reactive, SQL-only team to one that leverages Power BI more.
  • Administer the Power BI infrastructure for the organization (and install / configure new aspects)
  • Introduce automation and standard templates to reduce manual report requests (currently over 200 / month)
  • Work with the Data Engineering team to lay the foundation for scalable BI infrastructure and cloud migration (e.g., Snowflake, AWS)
  • Specifically, for this role as part of this team, the responsibilities during that time would be :

  • Data Modeling / Transformation Star / snowflake schema design, relationships, hierarchies, calculated columns, Power Query (M language) for clean / transform, tune models (column reduction, aggregations).
  • DAX Development – Measures, calculated tables, temporal functions (YTD, rolling averages, tune DAX, etc.
  • Dashboard / Report Development – Build dashboards / reports / visualizations / KPIs / drill -through / mobile-compatibility.
  • Data Sourcing – DirectQuery, import, composite models, SQL Server, Azure Synapse, data lakes, Excel, APIs, Power BI Service data refreshes, etc.
  • Security / Deployment – RLS / OLS, deployment pipelines, publish via Power BI Service, governance, etc.
  • KEY SKILLS :

  • Data Modeling – Enterprise-grade semantic models, star / snowflake schemas, composite models, tuning (VertiPaq Analyzer, etc.), aggregations, partitions, DirectQuery vs Import strategies.
  • DAX / Power Query (M Language) – Author, tune, statistical calculations, time intelligence, data shaping, ETL, automation, reusable dataflows, etc.
  • Data Sources – Azure Synapse, Data Lake, Databricks, SQL Server, APIs, Gateways, refresh scheduling, Power BI Embedded, Service Principals, PowerShell, REST APIs.
  • Security / Compliance – Row-Level Security (RLS), Object-Level Security (OLS), capacity / tenant settings, deployment pipelines, auditing / monitoring.
  • ETL Development – especially experience building and optimizing ETL pipelines (preferably using ADF, Databricks, data lakes, etc.)
  • Databricks – required for data processing and reporting pipeline development; expected to support future modernization
  • NICE TO HAVE REQUIREMENTS :

  • Power BI Administration Platform, Security / Governance, Data Infrastructure, Automation, Monitoring, Programming Languages (DAX, Power Query (M), Python, C#, R), Scalability)
  • Data Infrastructure Design / Administration – Gateways, periodic refreshes, version control.
  • Architectural Data Modeling & Warehousing Concepts – especially familiarity with performance optimization, schema design, and data integration strategies
  • EHR Data Experience – familiarity with data from healthcare systems (e.g., NextGen, myAvatar) is a plus, but not required
  • Healthcare Domain – Clinics, Hospitals, Behavioral Health
  • NOTABLE BENEFITS :

  • This position includes a full-time benefits package that is on par with standard offerings, including health insurance, paid time off, and related support. Additional details will be provided during the interview process. Medical, Dental, Vision, Life insurance, AD&D, Disability, FSA (healthcare / childcare), HSA, 401k
  • HOW TO APPLY :

    If you are a motivated and organized individual passionate about Information Technology, we would love to hear from you. To apply, please answer our applicant questions and submit your resume detailing your qualifications and relevant experience. We look forward to hearing from you!

    All Amplified Sourcing clients (including Amplified) are equal employers. They will consider all applicants without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.

    Job Posted by ApplicantPro

    serp_jobs.job_alerts.create_a_job

    Power Bi Engineer • Grandview, MO, US

    Job_description.internal_linking.related_jobs
    • serp_jobs.job_card.promoted
    CDL-A Intermodal Owner Operator - $0.58 to $0.64 per mile in De Soto, KS - Local

    CDL-A Intermodal Owner Operator - $0.58 to $0.64 per mile in De Soto, KS - Local

    AllTruckJobsDe Soto, KS, US
    serp_jobs.job_card.full_time
    SFT is seeking motivated new drivers for our regional intermodal team.Drivers in the regional sector can expect.All of our regional transportation loads are no-touch with round trip pay and built w...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    M&A Integration Manager

    M&A Integration Manager

    HFW CompaniesRaymore, MO, US
    serp_jobs.job_card.full_time
    Join the dynamic team at HFW Companies as an.The Integration Manager for M&A efforts is a newly created role at HFW, established due to our rapid growth. Reporting to the COO, this pivotal posit...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    CDL-A Intermodal Owner Operator - $0.58 to $0.64 per mile in Louisburg, KS - Local

    CDL-A Intermodal Owner Operator - $0.58 to $0.64 per mile in Louisburg, KS - Local

    AllTruckJobsLouisburg, KS, US
    serp_jobs.job_card.full_time
    SFT is seeking motivated new drivers for our regional intermodal team.Drivers in the regional sector can expect.All of our regional transportation loads are no-touch with round trip pay and built w...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Line Lead

    Line Lead

    CarvanaBelton, MO, US
    serp_jobs.job_card.full_time
    At Carvana, we sell cars but we aren't car salesmen.Our promise is simple : we won't sell a car to a customer that we wouldn't sell to our own Mom. To make sure our cars are in first-rate...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Work From Home - Take Surveys and Earn!

    Work From Home - Take Surveys and Earn!

    Prime InsightsLeavenworth, KS, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Join thousands of members already earning with top-paying surveys and offers.Get started today and enjoy competitive rewards, fast payouts with no waiting periods, and the flexibility to participat...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Fully Remote Survey Participant

    Fully Remote Survey Participant

    Prime InsightsLansing, KS, United States
    serp_jobs.filters.remote
    serp_jobs.job_card.full_time
    Join thousands of members already earning with top-paying surveys and offers.Get started today and enjoy competitive rewards, fast payouts with no waiting periods, and the flexibility to participat...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Take Surveys Get Paid!

    Take Surveys Get Paid!

    Prime InsightsLansing, KS, United States
    serp_jobs.job_card.full_time
    Join thousands of members already earning with top-paying surveys and offers.Get started today and enjoy competitive rewards, fast payouts with no waiting periods, and the flexibility to participat...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Databricks Data Engineer - Manager - Consulting - Location Open

    Databricks Data Engineer - Manager - Consulting - Location Open

    EYKansas City, MO, United States
    serp_jobs.job_card.full_time
    At EY, we're all in to shape your future with confidence.We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.Join EY and help ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    Business Intelligence Engineer

    Business Intelligence Engineer

    Concord USAKansas City, MO, US
    serp_jobs.job_card.full_time
    Concord isn't your typical consulting firm; we are an execution company with a passion for making things happen.Our mission is to help clients enhance customer experiences, optimize operations,...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Terminal Operator

    Terminal Operator

    ConGlobalHarrisonville, MO, United States
    serp_jobs.job_card.full_time
    Launch Your Career with ConGlobal .Whether you’re looking to grow your career or gain new skills, this role offers.Location : 1810 Bayard Avenue Kansas City, Kansas Kansas .Apprentice (No Experience...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Exp. Intermodal CDL-A Owner Operators - Home Time - Avg. $200k / Year

    Exp. Intermodal CDL-A Owner Operators - Home Time - Avg. $200k / Year

    Chicago Intermodal TransportationRaymore, MO, US
    serp_jobs.job_card.full_time
    Chicago Intermodal Transportation is Now Seeking CDL-A Owner Operators!.Now Seeking Intermodal Owner Operators - Average $200,000 per Year, Gross. Applicants must be a CDL-A licensed Owner-Operator ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_day
    • serp_jobs.job_card.promoted
    CDL-A Intermodal Owner Operator - $0.58 to $0.64 per mile in Pleasant Hill, MO - Local

    CDL-A Intermodal Owner Operator - $0.58 to $0.64 per mile in Pleasant Hill, MO - Local

    AllTruckJobsPleasant Hill, MO, US
    serp_jobs.job_card.full_time
    SFT is seeking motivated new drivers for our regional intermodal team.Drivers in the regional sector can expect.All of our regional transportation loads are no-touch with round trip pay and built w...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Infrastructure Engineer

    Infrastructure Engineer

    nFocus SolutionsLeavenworth, KS, US
    serp_jobs.job_card.full_time
    We are seeking Infrastructure Engineers responsible for deploying and maintaining Impact Level 5 (IL5) and Impact Level 6 (IL6) instances in AWS. The ideal candidates will have a strong background i...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Second shift Operator

    Second shift Operator

    ConGlobalGardner, KS, US
    serp_jobs.job_card.full_time
    Overview : Launch Your Career with ConGlobal ConGlobal is hiring immediately for a key role in our global supply chain operations. Whether you're looking to grow your career or gain new skills...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Senior Solutions Engineer

    Senior Solutions Engineer

    JobotKansas City, MO, US
    serp_jobs.job_card.permanent
    Global organization looking for Sr.Solutions Engineer for application development and IT transformation.This Jobot Job is hosted by : Brian Conklin. Are you a fit? Easy Apply now by clicking the &quo...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Freelance Data Collector

    Freelance Data Collector

    Prime InsightsLansing, KS, United States
    serp_jobs.job_card.full_time
    Join thousands of members already earning with top-paying surveys and offers.Get started today and enjoy competitive rewards, fast payouts with no waiting periods, and the flexibility to participat...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Top Loader Operator

    Top Loader Operator

    ConGlobalWeston, MO, United States
    serp_jobs.job_card.full_time
    Launch Your Career with ConGlobal .Whether you’re looking to grow your career or gain new skills, this role offers.Location : 1810 Bayard Avenue Kansas City, Kansas Kansas .Apprentice (No Experience...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    Sr Industrial Engineer

    Sr Industrial Engineer

    ID LogisticsEdgerton, KS, United States
    serp_jobs.job_card.full_time
    At ID Logistics we are dedicated to fostering a dynamic and inclusive work environment where every team member is welcomed and valued. As a leading global 3PL (3rd party logistics) transportation or...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days