What are the responsibilities and job description for the SQL/POWERBI/ADF DEVELOPER position at Veridic Solutions?
Requirements
• Expertise in Database Architecture in an environment that handles large volume of data.
• Experience with Azure Cloud & Azure Data Factory
• Strong analytical and organizational skills. This job involves analyzing existing databases and the client's needs to develop effective data driven solutions.
• Demonstrate expertise in performance tuning including both query and server optimization utilizing SQL tools and/or 3rd party solutions.
• Strong knowledge and experience in data modeling, database design, optimization for performance, SQL, stored procedures.
• Expertise in understanding complex business needs, analyzing, designing, and developing solutions.
• Experience in troubleshooting and resolving data related issues.
• Excellent oral and written communication skills.
• Expertise in performance tuning especially tuning complex queries, procedure, and indexing strategies.
• Monitor and perform tuning on complex ETL jobs.
• Audit/compliance experience in highly regulated environment.
• Familiar with Continual Improvement processes.
Experience
• 8 years relational database and SQL experience
• Must have experience with Azure Cloud, Azure Data Factory, and other tools within Azure Cloud
• Creativity, curiosity, initiative, and self-management are key attributes candidate embodies.
• Solid experience (4 years ) in coding complex SQL queries and stored procedures. The ability to explain the details of performance tuning internals of the database.
• Strong understanding of database development methodologies (Source Control, Continual improvement, Release Management, Agile and Scrum)
