We are unable to sponsor for this permanent Full time role
Position is bonus eligible, and requires working onsite 5 days per week
Prestigious Enterprise Company is currently seeking a Senior SQL Developer. Candidate will design and develop flexible data solutions to meet ever-changing company needs.
Responsibilities:
Support the processes to identify, capture and store data in data warehouse structure.
Collaborate with business and technology stakeholders.
Design, Maintain, and Enhance Data Models to support business initiatives. Design and develop integration/connections to various external and internal data sources.
Design and implement ETL procedures from both internal and outside sources while ensuring data quality.
Support implemented BI solutions and Analytics by monitoring performance, tuning queries, and troubleshooting database issues while upholding high standards of data integrity.
Perform project planning and resource allocation to meet project milestones.
Open, track, and resolve issues with vendors.
Standardize, organize, and document BI processes.
Expertise in ETL and writing stored procedures
Drive and participate in all stages of the development life cycle, from concept to planning, to developing, to testing/debugging, to delivery.
Work within an Agile environment to plan and deliver incremental projects in defined sprints.
Qualifications:
Required: Bachelor's Degree in Computer Science or similar.
Minimum of 5 years' experience in database development & architecture experience
Minimum of five (5) to ten (10) with SSIS projects
Experience in developing a semantic data layer for easy access of business users.
Experience creating logical models and translating into physical database structure. Both existing and proposed.
Strong knowledge and experience with T-SQL, SSIS, SSAS on SQL server, OLAP/PLTP, RDBMS design, dimensional modelling, SQL server, ETL and BI tools.
Demonstrated experience in Business Intelligence and data warehousing principles, approaches, technologies, and architectures.
Experience with one or more data visualization tools. (Tableau,etc.)
Experience with Cloud platforms and databases (Azure,AWS)
Scripting skills in Powershell
Scripting skills in Python
Understanding of data warehouse and relational database concepts such as Kimball and Inmon.
Demonstrated ability to solve problems of diverse scope and working in complex environments.
Proficient in data modelling tools.
Advanced SQL optimization and skills required.
Ability to work in cross functional teams and communicate with colleagues in both business and technical terms.
Performance tuning experience.