IT - Technology Specialist - IT Service, Support and Operations | Business Intelligence - Visualization | MSBI (Power BI)

Ampcus, Inc; Richardson (TX); On-site; USD 120,000 - 165,000; Full time

Job summary

Ampcus Inc. seeks an experienced data engineering/BI professional to support IT Service, Support, and Operations with advanced SQL, Python, and Power BI capabilities.

The role emphasizes dashboard development, ETL/ELT processes, data modeling, and data quality checks on enterprise datasets, including experience with HEDIS measures.

Qualifications

• 8–10 years of experience in SQL development, data analysis and troubleshooting on large-scale databases.
• Proficiency in Python for data transformation, automation, and data quality checks.
• Experience in Power BI development including dashboards, DAX, Power Query, data modeling and performance optimization.
• Experience in data engineering integration and ETL/ELT processes.

Responsibilities

• Strong SQL data skills across Snowflake and SQL Server for data validation and troubleshooting.
• Develop Power BI dashboards and optimize data models and performance; manage ETL/ELT pipelines.
• Apply HEDIS knowledge for quality reporting and validation of measure outputs.

Skills

SQL

Python

Power BI

ETL/ELT

Data Modeling

Snowflake

SQL Server

Data Analysis

Tools

Power BI Desktop

DAX

Power Query

Job description

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team.

Contract Duration

12 months

Detailed Job Description

We are seeking a candidate with strong expertise in various technical areas to support our IT Service, Support, and Operations. The ideal candidate will have advanced experience in SQL development, complex query optimization, stored procedures, data analysis, and troubleshooting across large-scale enterprise databases. Additionally, proficiency in Python programming for data transformation, automation, data quality checks, analytics, and building scalable data processing solutions is required. The candidate should also have experience in Power BI development, including dashboard development, DAX, Power Query, data modeling, and performance optimization. Experience in data engineering integration and ETL processes is essential.

Minimum Years of Experience

8-10 years

Top 3 Responsibilities

• Strong SQL Data Skills: Advanced querying, data validation, profiling, and troubleshooting across large datasets and platforms such as Snowflake and SQL Server.
• Power BI Development: Dashboard development, DAX, Power Query, data modeling, and performance optimization. Data engineering integration including ETL/ELT development, data ingestion, data migration, and multi-source integration.
• HEDIS Knowledge: Understanding and strong hands-on experience with HEDIS measures, quality reporting, and validation of measure outputs.

Interview Process

Is face to face required? Yes
Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.