Senior TSQL/ MSBI Developer
The senior TSQL/MSBI developer will design, build, and optimize SQL Server based data pipelines and reporting solutions using SSIS, SSRS, and Azure Data Factory. The role also involves creating data models and visualizations for finance projects on Azure Synapse and related services.
Skills required
About this role
SS&C is a leading provider of mission-critical, AI-powered technology and services empowering financial services and healthcare organizations to work smarter, faster, and securely. Founded in 1986, SS&C is headquartered in Windsor, Connecticut, and has offices worldwide. More than 23,000 financial services and healthcare organizations, from the world's largest companies to small and mid-market firms, rely on SS&C for expertise, scale, and technology.
Job Description
Job Description:
Experience with SQL BI Stack (T-SQL, SQL Server, SSIS, SSRS)
Experience with Azure Data Engineering Stack (Azure SQL Database, Azure SQL Managed Instance, Azure Analysis Services, Azure Data Factory, Logic Apps, Azure Logic Apps, Azure Synapse Analytics, Data Modeling, Azure DevOps).
Data visualization experience preferably on a finance related project using SSRS, or Paginated Reports
Hands-on experience modeling and optimizing large analytical databases using Analysis Services.
Hands-on experience with Azure Data Factory development projects.
Act as data engineer on the latest trends in the data analytics landscape and share best practices with the internal team.
Good knowledge of Data Modelling and Design concepts.
Proven track record of leadership roles delivering solutions within defined timeframes.
Must be strong in Data warehousing design aspects, OLAP dimensional modeling, Star Schema, Snowflake, and Best Practices.
Comfortable working in an agile delivery model.
Azure Data Engineer or Microsoft Power BI Data Analyst certification is added advantage.
Should be comfortable working in afternoon shift from 1 PM to 10:30 PM
Unless explicitly requested or approached by SS&C Technologies, Inc. or any of its affiliated companies, the company will not accept unsolicited resumes from headhunters, recruitment agencies, or fee-based recruitment services.
Applications will be accepted on an ongoing basis until the position is filled.
SS&C Technologies is an Equal Employment Opportunity employer and does not discriminate against any applicant for employment or employee on the basis of race, color, religious creed, gender, age, marital status, sexual orientation, national origin, disability, veteran status or any other classification protected by applicable discrimination laws.
