Data Warehouse Developer

Job Title: Data Warehouse Developer

Location: Rotherham Hybrid

Salary: Up to 40,000

Hours: Monday to Friday 9 am to 5:30 pm

Benefits:

• 25-day annual leave entitlement, plus bank holidays.
• Continuous Learning Program to keep you in the loop with relevant progression within the business and changes to economic mechanics, policies, and procedures.
• Free onsite parking.
• Employee assistance programme, and financial well-being support
• Great discounts with leading high street names.
• Professional body, annual subscription/membership (industry-related).
• Workplace Pension, Scottish Widows

About our Client:

Our client is a specialist lender that offers a supportive and engaging work environment with a focus on employee growth and development. With extensive learning opportunities, team-building activities like lunches and outings, and a collaborative atmosphere, employees likely feel valued and motivated to contribute. Additionally, the potential for advancement into more senior roles within the new business is an exciting prospect for those seeking career progression.

About the Role:

In this newly created role, reporting to the Head of IT, you'll be instrumental in designing, developing, and maintaining the company's data warehouse.

Responsibilities:

• Design and implement data models and schemas.
• Build and optimise ETL processes for seamless data integration from various sources.
• Develop efficient SQL queries for data retrieval and manipulation.
• Oversee data warehouse build, deployment, and maintenance.
• Ensure high data quality and integrity through validation and cleansing techniques.
• Implement best practices for data ingestion and transformation.
• Optimise database performance and troubleshoot any issues to ensure efficiency.
• Collaborate with business analysts, IT, and development teams to align on data requirements and system integration.
• Support ad hoc requests and maintain comprehensive documentation for workflows and processes.
• Provide support for data-related inquiries from end-users and ensure system availability.

Experience required:

• Proven experience in data warehousing, modelling, and database design.
• Proficient in SQL (SSMS) and ETL tools (e.g., SSIS, SAS DI, Informatica, Talend).
• Experience with data warehouse platforms (e.g., SQL Server, Redshift, BigQuery, Snowflake).
• Familiarity with BI tools (e.g., Power BI, Tableau).
• Strong understanding of DBMS and data warehousing concepts (e.g., star schema, snowflake schema).
• Scripting skills (e.g., SQL, Python, Shell)
• Experience with cloud-based data warehouses.
• Understanding of data governance and security best practices

Trusting Stellar Select:

At Stellar Select, our commitment goes beyond recruitment; it's about crafting experiences that elevate your career journey. We take pride in delivering excellent services to our candidates and always going the extra mile to ensure your success.

Our foundation is built on openness and transparency. We believe in clear communication with everyone we work with, fostering an environment of trust, honesty and fairness.

Embark on your career journey with confidence, knowing that our services are designed with your success in mind. Here's what our complimentary service includes:

• Expert Consultants: We are your allies, dedicated to understanding your goals and guiding you toward success.

• Industry Expertise: Benefit from our in-depth knowledge of the industry, providing you with insights that set you apart in your career.

• 1-2-1 Experience Discussion: Your experiences matter. Engage in personalised discussions about your journey and how it aligns with the job role.

• Interview Preparation: Step into interviews with confidence. We provide thorough preparation to ensure you shine in every interaction.

• Negotiation of Job Offers: We'll manage the negotiations on your behalf, aiming for offers that align with your expectations.

• Market Insights: Stay informed with the financial market insights that empower you to make informed career decisions.

• Recruitment Process Updates: No more uncertainty. We keep you in the loop with regular updates on your recruitment process.

• Matching to Other Roles: Your journey doesn't end with one opportunity. We explore matches to other roles based on your experience and interests.

• Referral Programs: Spread the word and be rewarded.

For more information regarding the role of Data Warehouse Developer please contact us

Stellar Select is acting as an employment agency and is a corporate member of the REC