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

Senior Power BI Engineer - Kansas City, MO

LEVERAGEncy, LLC (dba Amplified Sourcing)KCMO, MO, USA
job_description.job_card.variable_hours_ago
serp_jobs.job_preview.job_type
  • serp_jobs.job_card.full_time
  • serp_jobs.job_card.permanent
  • serp_jobs.filters_job_card.quick_apply
job_description.job_card.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 • KCMO, MO, USA

    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
    Capital Project Manager - I

    Capital Project Manager - I

    International Flavors and FragrancesNew Century, KS, United States
    serp_jobs.job_card.full_time
    Are you ready to lead multimilliondollar capital projects that enhance safety, quality, and performance at a worldclass manufacturing site?. IFF is a global leader in flavors, fragrances, food ingre...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
    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_less
    • 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_less
    • serp_jobs.job_card.promoted
    Production Team Leader - Engineer

    Production Team Leader - Engineer

    International Flavors and FragrancesNew Century, KS, United States
    serp_jobs.job_card.full_time
    This leadership role oversees production teams, including Packaging Technicians and Spray Operators, ensuring smooth operations, safety compliance, and quality output. The Team Leader manages shift ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_days
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Senior Power BI Engineer - Kansas City, MO

    Senior Power BI Engineer - Kansas City, MO

    LEVERAGEncy, LLC (dba Amplified Sourcing)Grandview, MO, US
    serp_jobs.job_card.full_time +1
    Power BI Engineer (Administration exposure a plus).The end client has indicated a budget of approximately $120,000 for a base salary, depending on experience (potentially higher, but requiring sign...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_1_hour
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    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_variable_hours
    • 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
    Billing and Coding Specialist

    Billing and Coding Specialist

    The Guidance CenterLeavenworth, KS, United States
    serp_jobs.job_card.full_time
    The Guidance Center (TGC) is the Community Mental Health Center and Certified Behavioral Health Clinic serving Leavenworth, Atchison, and Jefferson counties in Kansas. We provide high-quality care t...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    Senior R&D Engineer

    Senior R&D Engineer

    TVH AmericasOlathe, KS, United States
    serp_jobs.job_card.full_time
    Full-time | Sales - GemOne | Location - Olathe, KS, 66022.GemOne is a global tech company within TVH Parts Co.Smart Telematics solutions for optimal fleet performance management in multiple domain...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_30
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Lead Intermodal Equipment Operator

    Lead Intermodal Equipment Operator

    ConGlobalLinwood, KS, US
    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 : 32880 West 191st Street Edgerton, Kansas 66021 United States.Status...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    AI Data Engineer - Manager

    AI Data Engineer - Manager

    PwCKansas City, MO, United States
    serp_jobs.job_card.full_time
    At PwC, our people in business application consulting specialise in consulting services for a variety of business applications, helping clients optimise operational efficiency.These individuals ana...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 InsightsExcelsior Springs, MO, 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_less
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Top Loader Operator

    Top Loader Operator

    ConGlobalBucyrus, 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, this ...serp_jobs.internal_linking.show_moreserp_jobs.last_updated.last_updated_variable_hours
    • serp_jobs.job_card.promoted
    • serp_jobs.job_card.new
    Terminal Operator

    Terminal Operator

    ConGlobalPeculiar, 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