Senior Data Architect (BI/SQL)

Requirements:

• 8+ years of progressive experience in business intelligence, data engineering, data warehousing, database architecture, and/or SQL Server administration
• Expert-level SQL Server and T-SQL skills
• Hands-on experience with data warehouse architecture and dimensional modeling
• Experience designing conceptual, logical, and physical data models
• Strong ETL/ELT development background with SSIS and/or modern cloud data services
• Advanced Power BI skills, including data modeling, Power Query, DAX, security, deployment, and refresh administration
• Working knowledge of SSRS
• Production SQL Server DBA experience covering backup and recovery, security, monitoring, troubleshooting, migrations, upgrades, and high availability
• Strong SQL performance tuning and troubleshooting abilities
• Ability to independently lead complex technical projects from architecture through production
• Strong communication skills and ability to collaborate with technical and nontechnical stakeholders

Responsibilities:

• Design and maintain enterprise data warehouses, data marts, staging environments, semantic layers, and reporting architectures
• Create dimensional models using fact and dimension tables, star and snowflake schemas, and historical data strategies
• Develop and support production ETL/ELT pipelines using tools such as SSIS, Azure Data Factory, Microsoft Fabric, and T-SQL
• Integrate data from SQL Server, MySQL, Oracle, Azure SQL, APIs, files, and other enterprise systems
• Build governed Power BI datasets, semantic models, dashboards, KPIs, and executive reports
• Develop complex T-SQL, stored procedures, views, functions, tables, indexes, and data-processing routines
• Tune SQL Server performance and troubleshoot queries, ETL processes, reports, blocking, deadlocks, and resource issues
• Administer production SQL Server environments, including security, backup and recovery, disaster recovery, monitoring, migrations, upgrades, and availability
• Implement data-quality, reconciliation, auditing, lineage, logging, alerting, and error-handling processes
• Maintain data accuracy and consistency from source systems through final reporting
• Work with business leaders, analysts, application teams, and executives to turn business needs into scalable technical solutions
• Support the SDLC, testing, UAT, deployments, change control, documentation, and production incident response
• Provide architectural guidance, review code and designs, establish technical standards, and mentor team members
• Own solutions end to end, from requirements and architecture through development, deployment, optimization, and production support

Technologies:

• Architect
• Azure
• Business Intelligence
• Cloud
• Data Warehouse
• DAX
• ETL
• Fabric
• Support
• MySQL
• Oracle
• Power BI
• Power Query
• SQL
• Security
• Snowflake
• SSIS
• AI

More

We are an established, industry-leading organization in the renewable energy sector, operating at enterprise scale and continuing to modernize the technology and data platforms that support our business. We are hiring a senior, hands-on data professional for a hybrid role spanning business intelligence, data architecture, engineering, and database administration—not just dashboard development or traditional DBA work. The position offers a base salary of $160,000–$185,000 per year, with bonus potential, significant technical ownership, and the opportunity to build and architect across the full enterprise data lifecycle in a modern Microsoft-focused environment. You will work directly with business leaders, technical teams, and executive stakeholders and help shape technical standards and long-term data architecture. We provide an inclusive workplace and consider qualified candidates without discrimination.

last updated 43 week of 2026