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 Bachelor’s or Master’s 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 SYNECHRON’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 At Synechron, we believe in the power of digital to transform businesses for the better. Our global consulting firm combines creativity and innovative technology to deliver industry-leading digital solutions. Synechron’s progressive technologies and optimization strategies span end-to-end Artificial Intelligence, Consulting, Digital, Cloud & DevOps, Data, and Software Engineering, servicing an array of noteworthy financial services and technology firms. Through research and development initiatives in our FinLabs we develop solutions for modernization, from Artificial Intelligence and Blockchain to Data Science models, Digital Underwriting, mobile-first applications and more. Over the last 20+ years, our company has been honored with multiple employer awards, recognizing our commitment to our talented teams. With top clients to boast about, Synechron has a global workforce of 14,500+, and has 58 offices in 21 countries within key global markets. For more information on the company, please visit our website or LinkedIn community. At Synechron, we are committed to integrating sustainability into our business strategy, ensuring responsible growth while minimizing environmental impact. Employees play a key role in driving our sustainability initiatives, from reducing our carbon footprint to fostering ethical and sustainable business practices across global operations. All positions are required to adhere to our Sustainability and Health Safety standards, demonstrating a commitment to environmental stewardship, workplace safety, and sustainable practices. Not finding the right fit? Let us know you're interested in a future opportunity by clicking Get Started below or create an account by clicking 'Sign In' at the top of the page to set up email alerts as new job postings become available that meet your interest!