Power BI & ETL Developer | Data Modeling and Cloud Integration

Job Summary

Synechron is seeking a highly skilled ETL Power BI Developer to design, develop, and maintain data integration and visualization solutions that support enterprise analytics and decision-making. This role involves working closely with cross-functional teams to gather business requirements, build robust ETL pipelines, and create interactive dashboards leveraging Power BI and related tools. The ideal candidate will contribute to enhancing data-driven strategies, streamline data workflows, and support continuous improvement initiatives to maximize business value.

Software Requirements

Required Skills:

• Strong expertise in Power BI, including Power BI Desktop, Power BI Service, Dataflows, and Datasets

• Experience with ETL tools and processes supporting data ingestion, transformation, and modeling (e.g., SSIS, Azure Data Factory, or equivalent)

• Proficiency in SQL, with experience in complex query writing, data modeling, and performance tuning

• Hands-on experience with data management across structured, semi-structured, and unstructured data sources

• Familiarity with data warehousing concepts and dimensional modeling (star and snowflake schemas)

• Knowledge of data security, governance, and compliance standards

• Ability to work effectively with cross-functional teams, understanding business KPIs and translating them into technical solutions

Preferred Skills:

• Experience with cloud platforms like Azure or AWS for data storage and processing

• Knowledge of Data Lake architectures and big data tools (e.g., ADLS, Databricks)

• Familiarity with scripting languages such as Python or R for data processing and automation

• Experience with Power BI administration, deployment pipelines, and governance practices

Overall Responsibilities

• Design, develop, and optimize ETL processes and Power BI reports/dashboards supporting enterprise analytics needs

• Collaborate with business stakeholders to understand reporting requirements and KPIs; translate them into technical specifications

• Build data models and relationships to ensure accurate, scalable, and performant reports

• Automate data pipelines for data refresh, transformation, and integration workflows

• Develop and implement best practices for data security, access control, and documentation

• Monitor report performance, troubleshoot issues, and optimize visualizations for usability and efficiency

• Support data governance efforts, audit compliance, and documentation standards

• Stay current with advances in Power BI, data management, and analytics technologies, sharing best practices with the team

Technical Skills (By Category)

Languages & Scripting:

• Required: SQL, DAX, Power Query M, basic Python (preferred)

Data Management & Modeling:

• Data warehouse concepts, dimensional modeling (star/snowflake schemas), complex query writing, optimization techniques

Business Intelligence Tools:

• Power BI (Desktop, Service, Dataflows), Power BI Admin (preferred)

Cloud & Data Platforms:

• Azure Data Factory, Azure Data Lake, AWS Glue, S3 (preferred)

Databases:

• SQL Server, Azure SQL, Oracle, structured and semi-structured data sources

Automation & Orchestration:

• Data pipelines using Azure Data Factory, Databricks, or similar tools

Experience Requirements

• 4-14 years of experience in ETL development, data visualization, and BI reporting within enterprise environments

• Proven experience designing and delivering Power BI dashboards and data pipelines supporting operational and strategic decisions

• Strong SQL and data modeling skills, with a focus on performance tuning

• Hands-on experience working with cloud data platforms and automated data workflows

• Industry experience in finance, retail, or other data-driven sectors is a plus

Day-to-Day Activities

• Develop, test, and deploy scalable ETL workflows and Power BI reports/dashboards

• Collaborate with business users to gather requirements and translate KPIs into reports

• Optimize data models, queries, and refresh processes for performance and usability

• Troubleshoot data quality issues and dashboard performance bottlenecks

• Automate data ingestion, transformation, and visualization workflows

• Support ongoing data governance, security, and compliance initiatives

• Document data pipelines, report specifications, and best practices

• Participate in agile ceremonies, review sessions, and continuous improvement efforts

Qualifications

• Bachelor’s or Master’s degree in Computer Science, Data Science, Information Technology, or related fields

• 4-14 years of experience in ETL development, data visualization, and BI solutions

• Proven expertise in Power BI and enterprise data modeling

• Certifications in Power BI, Azure Data Solutions, or equivalent are advantageous

Professional Competencies

• Critical thinking and analytical skills for effective data interpretation and problem solving

• Excellent communication skills for engaging stakeholders and articulating technical insights

• Ability to manage multiple priorities and deliver solutions within deadlines

• Adaptability to evolving tools, data sources, and business requirements

• Strong teamwork and collaboration skills to work effectively across departments

• Continuous learner with a focus on best practices and innovation in data analytics

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.

Candidate Application Notice