Senior Power BI Architect
Apply NowCompany: Tata Consultancy Services
Location: Titusville, FL 32780
Description:
Must Have Technical/Functional Skills
Power BI Solution Architect, Performance tuning
Create and maintain robust Power BI solutions, including dashboards, reports, and data models that meet the analytical needs of various stakeholders across the organization.
Collaborate with data engineers and architects to design and implement data integration strategies that ensure seamless access to data from various sources. Utilize SQL for complex querying and data transformation.
Demonstrate strong knowledge of Data Analysis Expressions (DAX) to create complex calculations and aggregate data effectively within Power BI. Leverage DAX to optimize the performance of reports and analytics.
Ensure the optimization of database structures and performance by writing efficient SQL queries and stored procedures for data extraction, transformation, and loading (ETL) processes.
Engage with business stakeholders to understand their reporting needs, document requirements, and translate them into functional specifications for BI solutions.
Possess a strong ability to think outside the box and innovate solutions that enhance the overall functionality and utility of Power BI reports and dashboards. Embrace new ideas and approaches to overcome technical challenges and improve user experience.
Develop and maintain comprehensive documentation for BI developments, including design specifications, user manuals, and standard operating procedures. Promote best practices in data visualization and BI development.
Provide training and support to end-users on Power BI functionality, best practices in data interpretation, and dashboard utilization. Facilitate workshops to enhance data literacy within the organization.
Monitor the performance of BI solutions and data sources regularly, optimizing reports and dashboards for efficiency and user experience.
Work closely with cross-functional teams, including IT, business operations, and data governance, to align BI initiatives with organizational goals and ensure data integrity and security.
Redshift Experience:
o Partner with data engineers to ensure optimal data integration between Redshift and Power BI.
o Understand Redshift data models and query performance optimization techniques.
o Troubleshoot data access and refresh issues related to Redshift integration.
Additional responsibilities:
o Stay up to date with the latest Power BI features and functionalities.
o Provide technical support and guidance to Power BI users within the organization.
o Document processes and procedures related to Power BI administration.
Collaborate with other IT teams to ensure seamless integration of Power BI with existing systems.
Roles & Responsibilities
Highly motivated and experienced Power BI Archite ct who will play a critical role in managing, securing, and optimizing our Power BI solutions, ensuring high performance and scalability for the data analysts and business users.
Must have deep understanding of Power BI administration, implement the industry best practices, and performance tuning techniques.
Salary Range: $110,000-$125,000 a year
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
#LI-SP1
Power BI Solution Architect, Performance tuning
Create and maintain robust Power BI solutions, including dashboards, reports, and data models that meet the analytical needs of various stakeholders across the organization.
Collaborate with data engineers and architects to design and implement data integration strategies that ensure seamless access to data from various sources. Utilize SQL for complex querying and data transformation.
Demonstrate strong knowledge of Data Analysis Expressions (DAX) to create complex calculations and aggregate data effectively within Power BI. Leverage DAX to optimize the performance of reports and analytics.
Ensure the optimization of database structures and performance by writing efficient SQL queries and stored procedures for data extraction, transformation, and loading (ETL) processes.
Engage with business stakeholders to understand their reporting needs, document requirements, and translate them into functional specifications for BI solutions.
Possess a strong ability to think outside the box and innovate solutions that enhance the overall functionality and utility of Power BI reports and dashboards. Embrace new ideas and approaches to overcome technical challenges and improve user experience.
Develop and maintain comprehensive documentation for BI developments, including design specifications, user manuals, and standard operating procedures. Promote best practices in data visualization and BI development.
Provide training and support to end-users on Power BI functionality, best practices in data interpretation, and dashboard utilization. Facilitate workshops to enhance data literacy within the organization.
Monitor the performance of BI solutions and data sources regularly, optimizing reports and dashboards for efficiency and user experience.
Work closely with cross-functional teams, including IT, business operations, and data governance, to align BI initiatives with organizational goals and ensure data integrity and security.
Redshift Experience:
o Partner with data engineers to ensure optimal data integration between Redshift and Power BI.
o Understand Redshift data models and query performance optimization techniques.
o Troubleshoot data access and refresh issues related to Redshift integration.
Additional responsibilities:
o Stay up to date with the latest Power BI features and functionalities.
o Provide technical support and guidance to Power BI users within the organization.
o Document processes and procedures related to Power BI administration.
Collaborate with other IT teams to ensure seamless integration of Power BI with existing systems.
Roles & Responsibilities
Highly motivated and experienced Power BI Archite ct who will play a critical role in managing, securing, and optimizing our Power BI solutions, ensuring high performance and scalability for the data analysts and business users.
Must have deep understanding of Power BI administration, implement the industry best practices, and performance tuning techniques.
Salary Range: $110,000-$125,000 a year
TCS Employee Benefits Summary:
Discretionary Annual Incentive.
Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans.
Family Support: Maternal & Parental Leaves.
Insurance Options: Auto & Home Insurance, Identity Theft Protection.
Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement.
Time Off: Vacation, Time Off, Sick Leave & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
#LI-SP1