ETL Data Engineer
Typical Day in Role:
• Implementing data ingestion pipelines / DevOps (on prem and Azure cloud) to move data from source systems to our central data warehouse
• Developing SQL queries / ETL packages using T-SQL and SSIS to ingest data from source systems to integrate with data warehouse
• Design and development of high quality dashboards / reports using tools like Power BI, SSRS, Excel/PowerPivot and Tableau.
• Develop custom reports, analytics and KPI’s for the Business and Collecting business requirements / user stories from clients
• Complete testing to ensure high quality product for clients
• Developing SQL views to enable data consumers to read data from data warehouse
• Integrate systems via REST API, database views, SharePoint lists, sFTP, etc
• Responsible for documenting databases, data process flows and maintain data dictionaries
• Troubleshoot and resolve database and applications defects in a timely manner. Consult with internal and external groups as required
• Coordinating code deployments / production implementations.
• Train and assist users at all levels
Candidate Requirements/Must Have Skills:
1) 3-5 Years of SQL Development experience
2) 2-3 years of experience with Microsoft BI stack SQL Server, T-SQL, SSRS, MS SQL Enterprise Manager
3) Experience with data warehouse, ETL, SSIS to move data / integrate systems
4) Experience in developing BI reports and completing ad hoc queries and data analysis required
5) Expertise with data visualization / BI tools eg. Power BI, SSRS required.
Nice-To-Have Skills:
• Knowledge on Banking / Risk related systems is a plus
• Experience developing code to consuming REST API services a plus
• Experience integrating systems with COTS Commercial Off The Shelf software packages a plus
• Experience with implementing DevOps / MS Azure Cloud services, Google Cloud Platform etc a plus
• Experience with web development (in ASP.NET / SharePoint / Power Apps / Power Platform ) a plus
• Experience with Azure Data / Synapse / EDL / Hadoop / Hive / Jupyter Notebooks / Tableau a plus
Soft Skills:
• Clear communication and interpersonal skills required
• Attention to detail and feedback from clients on dashboards and reports must be completed rapidly
• Experience with Agile / Waterfall environments
Degrees or certifications:
• Bachelor’s degree in a technical field such as computer science, computer engineering or related field required