What are the responsibilities and job description for the Sr. Microsoft SQL Server Data Warehouse Developer position at Akkodis?
Akkodis is seeking a Sr. SQL Server Database Developer for a remote 6-12 month role. Qualified candidates will have experience in 7 years of experience in the design, development, and maintenance of data warehouse solutions using Microsoft SQL Server.
Pay Range : $55-65 per hour salary negotiable based on experience, education, geographic location, and other factors
This is a great opportunity with an innovative and growing employer!
Sr. SQL Server Database Developer job responsibilities include :
Data Warehouse Architecture and Development
Design, develop, and maintain data warehouse solutions using Microsoft SQL Server.
Define and implement data warehouse architecture, including data models, schemas, and pipelines.
Develop and optimize ETL processes using SQL Server Integration Services (SSIS) or other ETL tools.
Data Modeling and Design
Create and maintain logical and physical data models to support analytical reporting.
Implement star and snowflake schemas for effective data organization.
Ensure data warehouse design adheres to best practices for scalability and performance.
Data Integration and Transformation
Integrate data from multiple sources, including on-premises and cloud systems.
Develop and automate data pipelines to transform raw data into structured datasets.
Implement data validation, cleansing, and enrichment processes.
Performance Optimization
Analyze and improve the performance of the data warehouse environment.
Optimize database queries, indexing strategies, and storage structures.
Monitor and resolve performance issues related to ETL processes and reporting.
Collaboration and Stakeholder Engagement
Collaborate with business analysts, data scientists, and other stakeholders to gather data requirements.
Provide technical guidance and mentoring to junior developers and team members.
Translate business needs into technical data solutions.
Maintenance and Governance
Ensure data warehouse systems are secure, reliable, and compliant with organizational standards.
Implement backup, recovery, and disaster recovery strategies for the data warehouse.
Define and enforce data governance policies for quality, integrity, and security.
QUALIFICATIONS :
7 years of experience in data warehouse development, ETL, and database architecture.
5 years of hands-on experience with Microsoft SQL Server.
Expertise in Microsoft SQL Server (versions 2016 and above)
Proficiency in T-SQL development, stored procedures, and query optimization.
Strong experience with SSIS for ETL development.
Knowledge of dimensional data modeling and design (e.g., Kimball methodology).
Experience with PowerBI and Azure.
Familiarity with Azure Data Factory, Azure SQL Database, or other cloud data platforms.
Proficiency in scripting languages (e.g., Python, PowerShell) for data processing.
Strong problem-solving and analytical skills.
Excellent communication and presentation abilities.
Ability to lead projects and collaborate with cross-functional teams.
Attention to detail and commitment to data quality.
If you are interested in this remote Sr. SQL Server Data Warehouse Developer role, please click APPLY NOW. For other opportunities available at Akkodis go to
www.akkodis.com
- If you have questions about the position, please contact Kathy Becher at
216-750-6232
or kathy.becher@
akkodisgroup.com
Equal Opportunity Employer / Veterans / Disabled
Benefit offerings include medical, dental, vision, term life insurance, short-term disability insurance, additional voluntary benefits, commuter benefits and 401K plan. Our program provides employees the flexibility to choose the type of coverage that meets their individual needs. Available paid leave may include Paid Sick Leave, where required by law; any other paid leave required by Federal, State or local law; and Holiday pay upon meeting eligibility criteria. Disclaimer : These benefit offerings do not apply to client-recruited jobs and jobs which are direct hire to a client
To read our Candidate Privacy Information Statement, which explains how we will use your information, please visit
https : / / www.modis.com / en-us / candidate-privacy /
The Company will consider qualified applicants with arrest and conviction records.
Pay Details : $55.00 to $65.00 per hour
Benefit offerings available for our associates include medical, dental, vision, life insurance, short-term disability, additional voluntary benefits, EAP program, commuter benefits and a 401K plan. Our benefit offerings provide employees the flexibility to choose the type of coverage that meets their individual needs. In addition, our associates may be eligible for paid leave including Paid Sick Leave or any other paid leave required by Federal, State, or local law, as well as Holiday pay where applicable.
Equal Opportunity Employer / Veterans / Disabled
To read our Candidate Privacy Information Statement, which explains how we will use your information, please navigate to
https : / / www.akkodis.com / en / us / candidate-privacy-policy
The Company will consider qualified applicants with arrest and conviction records in accordance with federal, state, and local laws and / or security clearance requirements, including, as applicable :
Salary : $55 - $65
