BI Engineer | Power BI, SSRS & SQL

Synechron; Chennai District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Synechron in Chennai is seeking a Senior BI Engineer to design, develop, and optimize enterprise analytics solutions using Power BI, SSRS, and SQL. You will build robust data models, dashboards, and reports while enforcing data governance and performance.

Collaborate with data engineers, analysts, and stakeholders to translate requirements into scalable BI artifacts, mentor junior developers, and contribute to regulatory reporting and data storytelling for leadership.

Qualifications

• Strong hands-on experience with Power BI reports and dashboards.
• Proficiency in SQL and relational database design, data modeling, and query optimization.
• Hands-on experience with SSRS development for report creation.
• Experience with data modeling concepts (star/snowflake) and metadata management.
• Advanced Excel proficiency for data analysis and presentation.
• Experience with data visualization concepts and storytelling for leadership audiences.
• Familiarity with Agile software development methodologies and cross-functional teams.
• Knowledge of data governance, data quality, and data security practices.

Responsibilities

• Design, develop, and optimize enterprise BI solutions including Power BI reports, SSRS reports, and data models.
• Collaborate with data engineers, business analysts, and stakeholders to translate requirements into actionable BI solutions.
• Build scalable data models and dashboards to support key business KPIs and regulatory reporting.
• Ensure data quality, accuracy, and governance across BI platforms.
• Develop and maintain documentation for data models, data flows, and reporting artifacts.
• Mentor junior BI developers and promote best practices in reporting and data storytelling.

Skills

Power BI

SQL

SSRS

Data modeling

Excel

Agile

Data governance

Data visualization

Education

Bachelor's or Master's in CS/IT

Tools

SSIS

Azure Data Factory

Power BI administration

Dataflows

DAX Studio

Job description

## BI Engineer | Power BI, SSRS & SQLApplylocations: Chennai - Taramani (Ascendas)time type: Full timeposted on: Posted Todayjob requisition id: JR1041539**Job Summary** Synechron is seeking an experienced BI Engineer to design, develop, and optimize enterprise analytics solutions. This role focuses on delivering robust data models, reporting, and dashboards using modern BI tools, with a strong emphasis on data quality, governance, and performance. The successful candidate will collaborate with data engineers, analysts, product owners, and business stakeholders to enable actionable insights, drive data-driven decision making, and contribute to organizational growth and regulatory compliance.**Software Requirements****Required Skills (Essential)*** Strong hands-on experience with Power BI reports and dashboards* Proficiency in SQL and relational database design, data modeling, and query optimization* Hands-on experience with SSRS development for report creation* Experience with data modeling concepts (star/snowflake) and metadata management* Advanced Excel proficiency for data analysis and presentation (optional but beneficial)* Experience with data visualization concepts and storytelling for leadership audiences* Familiarity with Agile software development methodologies and working in cross-functional teams* Knowledge of data governance, data quality, and data security practices**Preferred Skills*** Experience with ETL/ELT tools (e.g., SSIS, Azure Data Factory) and data integration* Knowledge of data lakes and cloud data platforms (Azure, AWS, or GCP)* Experience with Power BI administration, dataflows, and deployment pipelines* Familiarity with NoSQL data stores and data warehousing concepts* Industry experience in banking/financial services or regulated sectors**Overall Responsibilities*** Design, develop, and optimize enterprise BI solutions including Power BI reports, SSRS reports, and data models* Collaborate with data engineers, business analysts, and stakeholders to translate requirements into actionable BI solutions* Build scalable data models and dashboards to support key business KPIs and regulatory reporting* Ensure data quality, accuracy, and governance across BI platforms* Develop and maintain documentation for data models, data flows, and reporting artifacts* Participate in sprint planning, backlog refinement, and cross-functional governance discussions* Drive improvements in BI performance, security, and maintainability* Mentor junior BI developers and promote best practices in reporting and data storytelling**Technical Skills (By Category)****Programming Languages (required and preferred)*** Essential: SQL* Preferred: DAX (Power BI), M (Power Query), Python for data manipulation or automation**Databases/Data Management*** Essential: Relational databases (SQL Server, MySQL, PostgreSQL, Oracle) and SQL data modeling* Preferred: NoSQL (e.g., MongoDB) and data warehousing concepts**Cloud Technologies*** Preferred: Cloud data services and deployment on Azure, AWS, or GCP* Essential: General cloud concepts and data security considerations**Frameworks and Libraries*** Essential: Power BI reporting, SSRS development* Preferred: Power BI dataflows, DAX Studio, and other BI tooling ecosystems**Development Tools and Methodologies*** Essential: Agile/Scrum practices; Jira/Confluence for requirements and tracking* Preferred: Data visualization tools (Tableau, Qlik) and BI administration tools**Security Protocols (if applicable)*** Essential: Data privacy, access controls, and secure data handling* Preferred: Data governance frameworks and regulatory compliance (e.g., GDPR, HIPAA)**Experience Requirements*** 6+ years of experience in BI/Analytics with strong Power BI and SSRS capabilities* Proven track record delivering enterprise BI solutions and dashboards* Experience working with cross-functional teams in an Agile environment* Banking/financial services or regulated industry experience is a plus but not mandatory* Alternative pathways: substantial BI project experience, relevant certifications, or contributions to BI platforms**Day-to-Day Activities*** Design, develop, and maintain Power BI and SSRS reports and dashboards* Collaborate with stakeholders to understand business requirements and translate them into BI solutions* Build and optimize data models, data flows, and reporting structures* Validate data quality and ensure governance across BI environments* Prepare leadership-level dashboards and executive status reports* Participate in sprint planning, stand-ups, and reviews* Create and maintain documentation for data models, pipelines, and reporting standards* Mentor junior BI colleagues and contribute to capability-building initiatives**Qualifications*** Bachelor's or Master’s degree in Computer Science, Information Technology, or a related field* Certifications related to Power BI, data analytics, or BI technologies are advantageous* Demonstrated experience delivering enterprise BI solutions with Power BI and SSRS**Professional Competencies*** Analytical thinking and strong problem-solving abilities* Clear communication and stakeholder management skills* Ability to lead or contribute effectively within cross-functional teams* Adaptability to evolving data technologies and regulatory requirements* Initiative and ability to drive continuous improvement* Time management and prioritization in a dynamic environment***S******YNECHRON’S DIVERSITY & INCLUSION STATEMENT***Diversity & Inclusion are fundamental to our culture, and Synechron is proud to be an equal opportunity workplace and is an affirmative action employer. Our Diversity, Equity, and Inclusion (DEI) initiative ‘Same Difference’ is committed to fostering an inclusive culture – promoting equality, diversity and an environment that is respectful to all. We strongly believe that a diverse workforce helps build stronger, successful businesses as a global company. We encourage applicants from across diverse backgrounds, race, ethnicities, religion, age, marital status, gender, sexual orientations, or disabilities to apply. We empower our global workforce by offering flexible workplace arrangements, mentoring, internal mobility, learning and development programs, and more.All employment decisions at Synechron are based on business needs, job requirements and individual qualifications, without regard to the applicant’s gender, gender identity, sexual orientation, race, ethnicity, disabled or veteran status, or any other characteristic protected by law.