Senior Data Architect (BI / SQL)

Fast Growing Renewables Company

This Jobot Job is hosted by: Milan Kacar
Are you a fit? Easy Apply now by clicking the "Apply Now" button and sending us your resume.
Salary: $160,000 - $185,000 per year

A bit about us:

We are an established, industry-leading organization with a large-scale operation and a continued focus on modernizing the technology and data platforms that support our business.

We are looking for a highly experienced Senior BI / Data Architect / SQL Server DBA to take hands-on ownership across our enterprise data environment. This is a unique hybrid role for someone who enjoys working across business intelligence, data architecture, data engineering, and database administration rather than being limited to one area.

Why join us?

$160-$185K base + bonus potential
High-impact senior technical role with significant ownership
Opportunity to architect and build, not just maintain existing systems
Ownership across the complete enterprise data lifecycle
Modern Microsoft-focused data and BI environment
Direct exposure to business leaders, technical teams, and executive stakeholders
Mix of new development, architecture, optimization, and modernization
Stable, established organization with complex enterprise-scale data challenges
Opportunity to influence technical standards and long-term data architecture

Job Details

We are seeking a senior, hands-on data professional who can own solutions from requirements and architecture through development, deployment, optimization, and production support.

This is not simply a Power BI/dashboard development position and not a traditional DBA role. The ideal candidate can architect the solution, build it, deploy it, and support it in production.

What You'll Be Doing
Design and maintain enterprise data warehouses, data marts, staging environments, semantic layers, and reporting architectures
Develop dimensional data models utilizing fact/dimension tables, star and snowflake schemas, and historical data strategies
Build and support production ETL/ELT pipelines using technologies such as SSIS, Azure Data Factory, Microsoft Fabric, and T-SQL
Integrate data across SQL Server, MySQL, Oracle, Azure SQL, APIs, files, and other enterprise systems
Build governed Power BI datasets, semantic models, dashboards, KPIs, and executive reporting
Develop complex T-SQL, stored procedures, views, functions, tables, indexes, and data-processing routines
Own SQL Server performance tuning and troubleshoot queries, ETL processes, reports, blocking, deadlocks, and resource issues
Administer production SQL Server environments, including security, backup/recovery, disaster recovery, monitoring, migrations, upgrades, and availability
Implement data-quality, reconciliation, auditing, lineage, logging, alerting, and error-handling processes
Ensure accuracy and consistency from source systems through final reporting
Partner directly with business leaders, analysts, application teams, and executives to translate business requirements into scalable technical solutions
Support SDLC, testing, UAT, deployments, change control, documentation, and production incident response
Provide architectural guidance, code/design reviews, technical standards, and mentorship to other team members

What We're Looking For
8+ years of progressive experience across BI, data engineering, data warehousing, database architecture, and/or SQL Server administration
Expert-level SQL Server and T-SQL
Strong hands-on experience with data warehouse architecture and dimensional modeling
Experience personally designing conceptual, logical, and physical data models
Strong ETL/ELT development experience with SSIS and/or modern cloud data services
Advanced Power BI experience including data modeling, Power Query, DAX, security, deployment, and refresh administration
Working knowledge of SSRS
Real-world production SQL Server DBA experience including backup/recovery, security, monitoring, troubleshooting, migrations, upgrades, and high availability
Strong SQL performance-tuning and troubleshooting skills
Ability to independently own complex technical projects from architecture through production
Strong communication skills with the ability to work directly with both technical and nontechnical stakeholders

The Ideal Profile
We're looking for someone who has personally designed the data model, written the complex SQL, built the production ETL pipeline, developed the Power BI solution, administered SQL Server, validated source-to-report accuracy, and troubleshot critical production issues.
This is an opportunity for someone who has built their career across the Microsoft data ecosystem and wants true end-to-end technical ownership, rather than being responsible for only one piece of the data stack.

Interested in hearing more? Easy Apply now by clicking the "Apply Now" button.

Jobot is an Equal Opportunity Employer. We provide an inclusive work environment that celebrates diversity and all qualified candidates receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, age (40 and over), disability, military status, genetic information or any other basis protected by applicable federal, state, or local laws. Jobot also prohibits harassment of applicants or employees based on any of these protected categories. It is Jobot's policy to comply with all applicable federal, state and local laws respecting consideration of unemployment status in making hiring decisions.

Sometimes Jobot is required to perform background checks with your authorization. Jobot will consider qualified candidates with criminal histories in a manner consistent with any applicable federal, state, or local law regarding criminal backgrounds, including but not limited to the Los Angeles Fair Chance Initiative for Hiring and the San Francisco Fair Chance Ordinance.

Information collected and processed as part of your Jobot candidate profile, and any job applications, resumes, or other information you choose to submit is subject to Jobot's Privacy Policy, as well as the Jobot California Worker Privacy Notice and Jobot Notice Regarding Automated Employment Decision Tools which are available at jobot.com/legal.

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Jobot, and/or its agents and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy here: jobot.com/privacy-policy