Associate Data Architect I

10 years

0 Lacs

Posted:17 hours ago| Platform: Linkedin logo

Apply

Work Mode

On-site

Job Type

Full Time

Job Description

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

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
UST logo
UST

IT Services and IT Consulting

Aliso Viejo CA

RecommendedJobs for You

trivandrum, kerala, india

trivandrum, kerala, india

kochi, thiruvananthapuram