SQL Server / Power BI Solutions Architect

Ascendion; Drummondville; Remote; CAD 130,000 - 145,000; Full time

Job summary

Ascendion seeks a Data Platform Architect with expertise in Power BI and SQL Server to design high-quality solutions for enterprise clients. This fully remote position requires strong technical skills in data warehousing and cloud integration, offering a competitive salary and comprehensive benefits.

Benefits

Medical insurance

Dental insurance

Vision insurance

401(k) retirement plan

Long-term disability insurance

Short-term disability insurance

5 personal days annually

10-15 days paid vacation time

6 paid holidays annually

Learning Management System

Qualifications

• Experience with Power BI development and embedded solutions.
• Expertise in SQL Server, including High Availability and Performance optimization.
• Strong understanding of data warehousing processes.

Responsibilities

• Design and implement Power BI solutions and SQL Server architectures.
• Optimize existing data solutions for performance and reliability.
• Assist in migrating solutions to Azure.

Skills

Power BI

SQL performance tuning

Data warehousing

DAX

High Availability

Disaster recovery

Azure SQL

Data modeling

Performance Optimization

Cloud Solutions

Education

Advanced certifications preferred

Job description

Ascendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. Headquartered in New Jersey, our workforce of 6,000+ Ascenders delivers solutions from around the globe. Ascendion is built differently to engineer the next.

Ascendion | Engineering to elevate life

We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us :

• Build the coolest tech for world’s leading brands
• Solve complex problems – and learn new skills
• Experience the power of transforming digital engineering for Fortune 500 clients
• Master your craft with leading training programs and hands-on experience

Experience a community of change makers!

Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.

About the Role :

Job Title : Customer Engineer / Solutions Architect / SQL Server / Power BI Solutions Architect / PFE / Premier Field Engineer / Field Engineer / Cloud Solutions Architect

We are seeking a skilled and experienced Data Platform architect with expertise in Power BI, Data Warehousing and SQL Server engine. Ideal candidate will be responsible for designing and implementing effective Power BI solutions, with a focus on Power BI Embedded, development, data warehouse integration, analytics and DAX expertise. For SQL Server, there should be a strong focus on Performance, High Availability, and Failover Clustering.

Ideal candidate will play a key role in design, development and optimization of Power BI and SQL Server implementations along with assisting in migration and modernization of solutions to Azure.

Skills / Job expertise needed :

• Enterprise level support and administration focused specifically on :
• Power BI, Power BI Embedded, SQL performance and tuning optimization, Clustering, Always On Availability groups, High Availability.
• Extensive experience with Power BI development including Power BI embedded skills.
• Power BI solution design, PBI embedded development skills and Performance optimization skills are required.
• Proficiency in DAX for developing complex calculations and measures.
• Strong understanding of Data Warehouse concepts and experience with integration of data warehouse.
• Solving performance problems, query tuning, and optimization
• SQL Server on IaaS experience on Azure / Other public cloud required.
• All versions of SQL Server (2012 and onwards)
• Architectural experience for Data Platform
• Architecting for High Availability and Disaster recovery solutions using FCI, Always on Availability groups
• Delivering and / or authoring technical training
• Advanced certifications preferred.
• Previous Consulting and / or customer facing role.
• Azure data factory, Azure SQLDB, Azure SQLDB Managed Instance, Azure Synapse knowledge is a plus.

Technical Skills :

• Power BI Solution design and embedded development.
• Data modeling and database design.
• DAX, Power Query M Language, development and optimization
• Data connectivity best practices to SQL, Oracle, MySQL, Azure, AWS and other services.
• Custom visualizations
• Power BI Row Level security along with other Security features.
• Performance Optimization and Tuning Capabilities
• Partitioning data implementations
• Database schema creation and management.
• Ensuring High availability and Disaster recovery.
• SQL code reviews with ability to dissect query plan, T-SQL code
• Data Encryption
• Auditing
• Replication of data
• SQL Edition and version differences with discontinued and deprecated features
• Upgrade process.
• Data Engine Capacity planning.
• General database management, Policy based management.
• Extended events and Traces
• Basic Licensing and support scenarios
• SQL Server Reporting service
• SQL Server Analysis Service

Location : Fully Remote within Canada

French-speaking Bilingual is a must-have.

Salary Range : CAD 130,000 - 145,000 Annually - Factors that may affect pay within this range may include geography / market, skills, education, experience, and other qualifications of the successful candidate.

Benefits : The Company offers the following benefits for this position, subject to applicable eligibility requirements : (medical insurance) (dental insurance) (vision insurance) (401(k) retirement plan) (long-term disability insurance) (short-term disability insurance) (5 personal days accrued each calendar year. The Paid time off benefits meet the paid sick and safe time laws that pertain to the City / State) (10-15 days of paid vacation time) (6 paid holidays and 1 floating holiday per calendar year) (Ascendion Learning Management System)

Want to change the world? Let us know.

Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table. Let’s talk!

Feel free to send your queries to or simply reach out to me @ [phone].

Create a job alert for this search