Senior Power BI Developer/Architect

GTN Technical Staffing; Dallas (TX); Hybrid; USD 120,000 - 190,000; Full time

Job summary

GTN Technical Staffing is seeking a Power BI Architect (AWS Redshift) to lead design and implementation of enterprise BI solutions. The ideal candidate will own semantic models, dashboards, and data structures, partnering with data engineers and stakeholders to deliver scalable reporting.

This hybrid role in North Dallas requires 7+ years BI experience, strong SQL, Redshift tuning, DAX, and governance. Must be US citizen or Greencard holder; work onsite 3 days a week.

Qualifications

• 7+ years of Business Intelligence and Data Analytics experience.
• 5+ years of hands-on Power BI development and architecture experience.
• Extensive experience with Amazon Redshift.
• Advanced SQL development skills.
• Strong understanding of dimensional data modeling (Star/Snowflake).
• Experience developing complex DAX measures and calculated columns.
• Experience with Power Query (M Language).
• Experience designing semantic models and enterprise datasets.
• Knowledge of Power BI Service administration and governance.
• Experience implementing Row-Level Security (RLS).
• Strong understanding of data warehouse concepts and analytics architecture.

Responsibilities

• Architect, design, and implement enterprise Power BI solutions using best practices for scalability, security, and performance.
• Design and develop semantic models, datasets, dataflows, and reusable reporting assets within the Power BI ecosystem.
• Build executive dashboards, operational reports, and interactive visualizations supporting business decision-making.
• Design and optimize Amazon Redshift data models for reporting and analytical workloads.
• Develop complex SQL queries, stored procedures, and performance tuning strategies within Redshift.
• Collaborate with Data Engineering teams to define ETL/ELT requirements and ensure data quality across enterprise data platforms.
• Implement row-level security (RLS), object-level security, governance, and workspace management within Power BI.
• Optimize report performance through efficient DAX calculations, data modeling, aggregations, and incremental refresh strategies.
• Establish enterprise BI standards, development methodologies, documentation, and governance practices.
• Work closely with business stakeholders to gather reporting requirements and translate them into technical solutions.
• Troubleshoot reporting issues, data discrepancies, and performance bottlenecks.
• Mentor developers and analysts on Power BI development standards and best practices.
• Participate in architecture reviews and recommend enhancements to modernize reporting platforms.
• Support deployment pipelines, source control, and CI/CD processes for Power BI solutions.

Skills

Power BI Architecture

Amazon Redshift

SQL Development

Dimensional Modeling

DAX

Power Query

ETL/ELT

Data Warehousing

Governance

CI/CD

Education

Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field

Tools

Power BI

Amazon Redshift

SQL

Power Query

DAX

Git

Jira

Confluence

Azure DevOps

Job description

Hybrid Role in the Dallas Metroplex (MUST BE ABLE TO WORK 3 DAYS A WEEK ONSITEI)

Must be Greencard or US Citizen

Job Title: Power BI Architect (AWS Redshift)

Location: HYBRID IN NORTH DALLAS

Job Type: Full-Time

Position Overview

We are seeking an experienced Power BI Architect with strong expertise in Amazon Redshift to lead the design, architecture, and implementation of enterprise business intelligence and analytics solutions. The ideal candidate will possess a deep understanding of data warehousing, dimensional modeling, data visualization, and cloud-based analytics while serving as the technical leader for Power BI initiatives.

This role will partner with business stakeholders, data engineering teams, and application developers to build scalable reporting solutions that transform complex data into meaningful business insights. The successful candidate will have experience optimizing Redshift data models for analytics and developing enterprise-grade Power BI semantic models, dashboards, and reporting frameworks.

Key Responsibilities

• Architect, design, and implement enterprise Power BI solutions using best practices for scalability, security, and performance.
• Design and develop semantic models, datasets, dataflows, and reusable reporting assets within the Power BI ecosystem.
• Build executive dashboards, operational reports, and interactive visualizations supporting business decision-making.
• Design and optimize Amazon Redshift data models for reporting and analytical workloads.
• Develop complex SQL queries, stored procedures, and performance tuning strategies within Redshift.
• Collaborate with Data Engineering teams to define ETL/ELT requirements and ensure data quality across enterprise data platforms.
• Implement row-level security (RLS), object-level security, governance, and workspace management within Power BI.
• Optimize report performance through efficient DAX calculations, data modeling, aggregations, and incremental refresh strategies.
• Establish enterprise BI standards, development methodologies, documentation, and governance practices.
• Work closely with business stakeholders to gather reporting requirements and translate them into technical solutions.
• Troubleshoot reporting issues, data discrepancies, and performance bottlenecks.
• Mentor developers and analysts on Power BI development standards and best practices.
• Participate in architecture reviews and recommend enhancements to modernize reporting platforms.
• Support deployment pipelines, source control, and CI/CD processes for Power BI solutions.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent experience).
• 7+ years of Business Intelligence and Data Analytics experience.
• 5+ years of hands-on Power BI development and architecture experience.
• Extensive experience with Amazon Redshift.
• Advanced SQL development skills.
• Strong understanding of dimensional data modeling (Star Schema and Snowflake Schema).
• Experience developing complex DAX measures and calculated columns.
• Experience with Power Query (M Language).
• Experience designing semantic models and enterprise datasets.
• Knowledge of Power BI Service administration and governance.
• Experience implementing Row-Level Security (RLS).
• Strong understanding of data warehouse concepts and analytics architecture.

Preferred Qualifications

• Experience with AWS cloud services including:
• Amazon S3
• AWS Glue
• AWS Lambda
• Amazon Athena
• Amazon RDS
• Amazon EMR
• Experience with Microsoft Fabric or Azure Synapse Analytics.
• Experience with Snowflake, SQL Server, or other enterprise data warehouses.
• Experience with ETL/ELT tools such as Informatica, Talend, Matillion, dbt, or AWS Glue.
• Knowledge of Python or R for analytics.
• Experience with DevOps and CI/CD deployment pipelines.
• Familiarity with Git or Azure DevOps.
• Experience working in Agile/Scrum environments.

Technical Skills

• Microsoft Power BI
• Power BI Service
• Power BI Desktop
• Power Query
• DAX
• Dataflows
• Paginated Reports (preferred)

Data Platforms

• Amazon Redshift
• SQL Server
• Snowflake (preferred)
• Microsoft Fabric (preferred)
• AWS
• Amazon S3
• AWS Glue
• Lambda
• IAM

Database & Development

• Advanced SQL
• Data Modeling
• ETL/ELT
• Performance Tuning
• Data Warehousing
• API Integration (preferred)
• Git
• Jira
• Confluence

Preferred Experience

• Enterprise reporting architecture
• KPI and scorecard design
• Operational reporting
• Manufacturing, Supply Chain, Retail, Healthcare, or Financial Services analytics
• Large-scale cloud data warehouse implementations
• Data governance and BI strategy
• Strong analytical and problem-solving skills
• Excellent communication and presentation abilities
• Ability to translate business requirements into technical solutions
• Leadership and mentoring experience
• Strong attention to detail
• Ability to manage multiple priorities in a fast-paced environment
• Passion for data visualization and business intelligence best practices

Nice to Have

• Microsoft Certified: Power BI Data Analyst Associate
• Microsoft Fabric Certification
• AWS Certified Data Analytics – Specialty
• AWS Solutions Architect Certification
• Experience with AI-assisted analytics, Copilot for Power BI, or Microsoft Fabric AI capabilities
• Experience implementing enterprise BI governance frameworks

This position is ideal for a senior-level BI professional who can architect end-to-end analytics solutions, optimize Amazon Redshift for reporting, and establish enterprise Power BI standards while delivering scalable, high-performance business intelligence platforms.