Title: ETL/BI/Data Developer
Location: Onsite, St. Louis, MO (Local to Missouri )
Duration: 6+ Months
MOI: Phone then Video
Visa: No H1B
Looking for onsite resource who has Azure Synapse skills, SSIS skills and Power BI skills as a third possibility – Azure Synapse and SSIS are the primary skills we are looking for
½ time support ½ time development
5+ years of experience
The resource will work closely with our Data Lead on support items on a day to day basis but will also work on development efforts
Highlighted most important from below list of needs
Design and maintenance of SQL server data warehouse, data management, various DataMart’s SSIS packages and SSAS, business rules, various reports, Power BI dashboards, scoreboards, and other solutions requests.
Job Description
Closely work with other team members and different department leaders, architects to analyze and help design, develop, support Microsoft full stacks (SSIS, SSAS, SSRS and ADF.) Business intelligence reports, scorecards, data structures, and dashboards.
Consulting with internal and external clients to model enterprise-wide complex data structures including master data management
Participate in development and maintenance of the database architecture and recommend solutions to business needs including creating structure where none exists for reporting/analytics database solutions using modern techniques and programming language
Designs, develops, tests, monitors, manages, and validates data warehouse data activities, including data extraction, transformation, movement, loading, cleansing and updating processes .
Will participate in multiple projects simultaneously
Works harmoniously in a cross-functional team comprised of managers, supervisors, business analysts, systems personnel and other developers in ensuring the delivery of EDW solutions as planned, on time and within the budget
Develop and maintain the appropriate operational documentation for EDW solutions
Ensure the accuracy, performance and consistency of the EDW information
Perform health checks to ensure the integrity of the EDW data, and the synchronization of EDW.
SQL Server EDW developer, including designing and developing solutions.
Convert business requirements to concept/ technical specification
Data modelling in preparing the data/ dimensional models in Azure Data lake
Advance knowledge of Azure SQL DB & Synapse Analytics, Power BI, T-SQL, Logic Apps , Function Apps
Monitoring day to day Data factory pipeline activity
Knowledge of master data management, data warehousing and business intelligence architecture.
Knowledge of Azure data lake is required and Azure Services like Analysis Service, SQL Databases, Azure
DevOps, CI/CD
Design and implementation of data integration that are innovative, scalable and high performing within SSIS & ADF.
Rich understanding of EDW (data warehousing) concepts, architectures and business processes and ability to Perform systems and data analysis for implementation of EDW, ETL and DataMart
Expert-level ability writing complex and performance queries in SQL.
Rich understanding of data architectural and design patterns including normalized, dimensional, data vault, and multi-dimensional approaches.
Willingness to learn and experiment with technologies outside of his/her comfort area.
Excellent interpersonal skills and ability to work with all levels of personnel individually and within teams. Good communication skills, both verbal and written.
Conduct or coordinate tests to ensure that intelligence is consistent with defined needs.
Maintain library of model documents, templates, or other reusable knowledge assets.
Create or review technical design documentation to ensure the accurate development of EDW solutions.
Document specifications for business intelligence or information technology (IT) reports, dashboards, or other outputs.
Thank You!
Udit Dabas| Sr. Technical Recruiter
D: 215-278-8860| E: udit.dabas@firstringsolutions.com
First Ring Solutions LLC | Philadelphia, PA 19102
Note: Due to high volume of calls, I may miss your call, email is the better way to reach me.