For job seekers, BONAPOLIA offers a gateway to exciting career prospects and the chance to thrive in a fulfilling work environment.
We believe that the right job can transform lives, and we are committed to making that happen for you.
We're looking for a talented Senior SQL Developer with experience implementing solutions and solving complex client problems. In this role, you will be responsible for achieving a high satisfaction rating from clients by successfully implementing software solution projects.
About Our Customer
The health and fitness software and payment processing provider in the United States, Puerto Rico, Canada, and Mexico. Founded in 1981, they currently work with 7,000+ health clubs. Customer offerings include payment processing and gym management solutions that allow managers to track memberships and schedules and automate payment processing functions.
Requirements
3+ years of proven work experience as a Database Engineer / ETL Developer
Background in Data warehouse Design & Architecture
Skills in SQL / ETL Performance Tuning
SQL knowledge
Proficiency in working with DBMS and ETL tools
Knowledge of data modeling principles
Practice in SQL / NoSQL data storage mechanisms and Big Data technologies
Experience with Azure cloud or Microsoft SQL or MPP DBMS will be a big plus
High attention to detail
Passionate about complex data structures and problem solving
Nice to Have
Competency in Microsoft stack
English level: Intermediate+
Responsibilities
Develop and implement ETL solutions, updating the architecture of our databases as necessary
Develop or update SQL queries and scripts
Work with business stakeholders to assist with data modeling or outlining the data requirements to support our business processes
Develop source-to-target mapping, or data transformation instructions that outline how to convert data in the source system to the target system as well as map the data values
Test databases and troubleshoot any issues
Expectations from the Candidate:
Strong SQL / ETL Developer (Microsoft stack preferable)
Data warehouse Design & Architecture principles.
SQL / ETL Performance Tuning
In other words, the candidate should act as Database Engineer on DWH project.
What do we have:
Azure Synapse dedicated SQL pool (SQL / T-SQL) - 55%
Azure Data Factory - 30%
PowerBI Paginated Reports (dataset part mostly) (SSRS) - 10%
PowerBI semantic models + Reports / dashboards on top of it - 5%
Challenges:
ETL performance issues
DataMart performance issues
Data quality issues (requires lineage analysis)
Issues related to the performance of dedicated SQL pool in general (number of max concurrent connections, quality of model / code, etc)
Our Synapse Dedicated is on DW15000c level, one step before maximum possible performance level. And still we have periods when the system is under pressure with 700+ ETL pipelines.
#J-18808-Ljbffr