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

Ampcus Inc; Richardson (TX); On-site; USD 110,000 - 150,000; Full time

Job summary

Ampcus Inc. is seeking a senior data engineering specialist with strong SQL, Python, and Power BI skills to support IT service, support, and operations.

The ideal candidate will have extensive experience in SQL development, data transformation, and data quality checks across large enterprise databases, along with ETL/ELT development and multi-source integration. Proficiency in Power BI development, including dashboarding, DAX, and data modeling, is required, as is hands-on data engineering

Qualifications

• 8–10 years of experience in SQL development and data engineering.
• Proven ability to optimize complex queries across enterprise databases.
• Strong Python data transformation, automation, and analytics capabilities.
• Power BI development including dashboarding, DAX, and data modeling.

Responsibilities

• Strong SQL data skills across Snowflake and SQL Server for data validation and troubleshooting.
• Develop Power BI dashboards, models, and optimize performance.
• Lead data engineering ETL/ELT development and multi-source data ingestion.

Skills

SQL

Python

Power BI

ETL

Data modeling

Tools

Snowflake

SQL Server

Power BI

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.