Customer Engineer

About Ascendion: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 the world’s leading brandsSolve complex problems - and learn new skillsExperience the power of transforming digital engineering for Fortune 500 clientsMaster your craft with leading training programs and hands-on experienc

e

Experience a community of change-maker

s!

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 Ascendi

on.

About the Role: Customer Engineer - 100% Re

mote

Job Title: Customer EngineerResponsibilitiesFocused on delivering proactive services such as education workshops, delivering assessments and providing expert guidance.Train customers and share industry and development expertise.Be part of a thriving developer community that's constantly looking for ways to improve our customers’ experience, software development goals and use of technology.Build strong customer relationships and ensure deliveries align with customer projects and milestones.Gain access to expertise and support from Clent’s consulting practice and product group.Growth MindsetTroubleshooting/Problem AnalysisMaintain, extend accreditations and certifications, assist in developing best practices for key technologies and products to support technical team readinessDemonstrate strong communication skills; ability to develop strategic ongoing customer relationships, gain trust and respect for Client Premier.Engineers must also possess strong technical writing, presentation and training skillsWe are seeking a skilled and experienced SQL Server & SSAS Solution Architect with expertise in SQL Server, Data Warehousing, Analysis Services. For SQL Server, there should be a strong focus on Performance, High Availability, and Failover Clustering. For SSAS, ideal candidate will play a key role in designing, developing and optimizing SSAS solutions to support business intelligence and analytics initiat

ives.

Minimum Qualifications:Proven experience as an SSAS Development/ administration with a focus on Data Warehousing.Experience with multidimensional and Tabular cubesIn-depth knowledge of SQL Server, T-SQL, MDX, and DAX.Strong understanding of performance tuning methodologies.Experience in configuring and maintaining SQL Server high availability and failover clustering.Excellent problem-solving and troubleshooting skills.Ability to work collaboratively in a team environment.Strong communication skills to effectively interact with stakeholders.Previous Consulting and/or customer-facing

role.

Required Skill SetSQL ServerEnterprise-level support and administration focused specifically with:SQL performance and tuning optimization, Clustering, Always On Availability groups, High Availability, Core SQL +Migration, on-premise and cloud.All versions of SQL Server (2012 and onwards)Solving performance problems, query tuning, and optimizationArchitectural experience for Data PlatformArchitecting for High Availability and Disaster recovery solutions using FCI, Always on Availability groupsDelivering and/or authoring technical trainingSQL Server Integration Services, Reporting Services, Analysis ServicesSQL Server on IaaS experience on Azure/ Other public cloud.Azure data factory, Azure SQLDB, Azure SQLDB Managed Instance, and Azure Synapse knowledge are a plus.SSAS/ Data Warehouse/ ReportingDesign, develop, and maintain SSAS cubes, dimensions, and data models.Multidimensional and tabular cubesMDX query writing, SSAS Performance, health checks/ best practices.Implement and optimize MDX and DAX queries for efficient data retrieval and analysis.Work closely with business analysts to understand reporting requirements and translate them into SSAS solutions.Scalability of SSAS and high availability of SSAS.Power BI development and administration

skills

Technical Skills:Data modeling and database design.Indexing strategyPerformance Optimization and Tuning CapabilitiesPartitioning data implementationsMetadata management and repository usage.Database schema creation and management.Backup and recovery.Ensuring data integrity.Ensuring High availability and Disaster recovery.SQL code reviews with the ability to dissect query plans, T-SQL codeProcedural skills.Data security.Data EncryptionAuditingReplication of dataSQL Edition and version differences with discontinued and deprecated featuresUpgrade processStorage management techniques.Data Engine Capacity Planning.General database management, Policy-based management.Windows Failover ClusteringSQL Server Reporting serviceSQL Server Integration ServiceSQL Server Analysis ServiceMDX Query writing and tuningSSAS administration, best practices, and health checksPow

er Shell

Location: 10

0% Remote

Salary Range: The salary for this position is between $90K/year- $115K. 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 day accrued each calendar year. The Paid time off benefits meet the paid sick and safe time laws that pertains to the City/ State] [10-15 day of paid vacation time] [6 paid holidays and 1 floating holiday per calendar year] [Ascendion Learning Managem

ent System]

Want to change the world?

Let us know.