Data Engineer Data Analyst | SQL, Power BI & Data Warehousing

Job Summary

Synechron is seeking two experienced Data Engineers / Data Analysts to work within our Financial Data Index & Analytics domain. These roles are pivotal in designing developing and maintaining enterprise-grade data solutions that support business analytics and decision-making processes. The successful candidates will leverage their technical expertise to build robust data models optimize performance and deliver insightful visualizations that drive business growth. These roles are essential for converting complex financial datasets into strategic intelligence fostering data-driven decision-making across the organization.

Software Requirements

Required Skills:

• Advanced SQL (T-SQL) including CTEs Window Functions Dynamic SQL and complex Joins

• Experience with SQL Server and Azure SQL for data transformation and warehousing projects

• Power BI Desktop & Power BI Service for creating dashboards reports and datasets

• Knowledge of data modeling techniques such as Star Schema and Snowflake Schema

• Experience with Azure Synapse Analytics Databricks and related data lake technologies

• Strong understanding of Data Warehousing methodologies including slowly changing dimensions (SCD Type 1 2 3) aggregate tables and fact tables

Preferred Skills:

• Exposure to Microsoft Fabric and OneLake

• Python (Pandas NumPy) for data processing and automation

• Experience with Azure Analysis Services and SSAS Tabular Models for enterprise semantic layers

Overall Responsibilities

• Design develop and optimize enterprise data warehouse solutions and dimensional models aligned with business requirements

• Write complex T-SQL scripts stored procedures views and functions for data transformation and reporting

• Implement indexing and query tuning strategies to optimize performance

• Build interactive dashboards and reports in Power BI ensuring data accuracy and visual clarity

• Collaborate with cross-functional teams to gather requirements translate them into technical solutions and support ongoing data initiatives

• Maintain and enhance data pipelines and ETL processes ensuring data integrity and high performance

• Support ad-hoc data analysis using Excel Power Query and Power Pivot for senior management

• Stay updated with emerging technologies and best practices in data warehousing BI and analytics

Technical Skills (By Category)

Programming Languages:

• Required: T-SQL Power BI DAX Power Query M language

• Preferred: Python (Pandas NumPy)

Databases & Data Management:

• SQL Server Azure SQL Data Warehouse modeling SCD Types Fact/Dimension tables

Cloud Technologies:

• Azure Synapse Analytics Azure Data Lake Databricks (preferred)

Frameworks & Libraries:

• Power BI SSAS Tabular Models Azure Analysis Services

Development Tools & Methodologies:

• SQL Server Management Studio (SSMS) Visual Studio Power BI Desktop Agile/Scrum practices

Security & Data Governance:

• Data privacy protocols role-based access control data validation

Experience Requirements

• 5 years of experience in data engineering data analysis or related fields

• Demonstrable experience in managing large-scale financial datasets and reporting

• Proven expertise in SQL development data modeling for data warehouses and BI report creation

• Experience working directly with business stakeholders to deliver analytics solutions

• Strong track record in performance tuning indexing strategies and ETL frameworks

Day-to-Day Activities

• Design and develop scalable data models and APIs for financial data analysis

• Create and schedule Power BI dashboards and reports for various business units

• Optimize data pipelines troubleshoot performance issues and enhance data quality

• Engage with business users to gather requirements and deliver actionable insights

• Document configurations processes and best practices to support ongoing maintenance

• Review and improve data governance and security standards

• Collaborate with team members to support data migrations upgrades and new initiatives

Qualifications

• Bachelors or Masters degree in Computer Science Information Technology Data Science or related fields

• Relevant certifications in SQL Server Power BI Azure Data Fundamentals or equivalent (preferred)

• Professional experience in financial services or index & analytics domain is highly advantageous

Professional Competencies

• Strong analytical and problem-solving skills with an eye for detail

• Excellent communication skills for engaging with technical and non-technical stakeholders

• Ability to work independently and collaboratively in a fast-paced environment

• Adaptability to evolving data tools and business requirements

• Strong organizational skills and time management to handle multiple priorities

SYNECHRONS 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 applicants gender gender identity sexual orientation race ethnicity disabled or veteran status or any other characteristic protected by law.

Candidate Application Notice