Associate Data Architect I

Year    KL, IN, India

Job Description

9 - 12 Years
1 Opening
Kochi, Trivandrum


Role description




Seeking an experienced BI Developer with over 10 years of expertise in designing, developing, and optimizing Business Intelligence solutions leveraging SQL Server, Salesforce, GCP, PostgreSQL, Power BI, and Tableau. The ideal candidate will have strong data modeling skills, advanced database programming experience, and the ability to collaborate effectively with business stakeholders.


Key Responsibilities




Develop, maintain, and optimize BI applications and solutions using SQL Server, Power BI, Tableau, and cloud platforms such as GCP. Design and implement data models including Star Schema, Snowflake Schema, Fact, and Dimension tables to support robust analytics. Translate business requirements into detailed functional and non-functional specifications. Communicate and collaborate with C-suite executives and stakeholders to ensure BI solutions meet business needs. Write and optimize complex T-SQL queries, stored procedures, user-defined functions, triggers, views, and indexes. Design and develop SSAS OLAP cubes and create complex DAX measures for interactive dashboards and reports. Utilize tools like Tabular Editor and DAX Studio to enhance and troubleshoot data models. Implement incremental data refresh, row-level security (RLS), parameterization, dataflows, and data gateways to ensure secure and efficient data delivery. Build and optimize reports using SSRS and Power BI, employing mixed and direct query modes to improve performance.

Required Skills




Extensive experience with SQL Server, T-SQL programming, and database design principles. Strong knowledge of data modeling techniques including dimensional and relational models. Proficiency in Power BI and Tableau for report development and dashboarding. Expertise in SSAS (Multidimensional and Tabular models) and writing complex DAX expressions. Familiarity with cloud platforms such as Google Cloud Platform (GCP) and Salesforce integration. Hands-on experience with BI tools such as Tabular Editor, DAX Studio, and SSRS. Ability to write and optimize stored procedures, functions, triggers, and queries for complex business logic. Experience with data security implementation, including Row-Level Security (RLS) and parameterized data access. Strong communication skills and ability to engage with executives and stakeholders to translate business needs into technical solutions.

Qualifications




Bachelor's degree in Computer Science, Information Technology, Data Analytics, or related field. 10+ years of professional experience in Business Intelligence development and data engineering. Proven track record of designing and delivering scalable BI solutions in enterprise environments. Certifications in Microsoft BI technologies, Power BI, or relevant cloud platforms are a plus.

Skills




Power Bi,Power Tools,Data Analysis,Fabric



About UST




UST is a global digital transformation solutions provider. For more than 20 years, UST has worked side by side with the world's best companies to make a real impact through transformation. Powered by technology, inspired by people and led by purpose, UST partners with their clients from design to operation. With deep domain expertise and a future-proof philosophy, UST embeds innovation and agility into their clients' organizations. With over 30,000 employees in 30 countries, UST builds for boundless impact--touching billions of lives in the process.

Beware of fraud agents! do not pay money to get a job

MNCJobsIndia.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Job Detail

  • Job Id
    JD4058737
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    KL, IN, India
  • Education
    Not mentioned
  • Experience
    Year