Summary: The Senior Data Warehouse Developer will oversee building data warehouse solutions and providing technical leadership within the Data Analytics team. They work closely with cross-functional teams to architect, design, develop, and maintain scalable data warehouse solutions using Snowflake and related technologies.
The Senior Developer – Data Warehouse encompasses a diverse array of responsibilities spanning data engineering, architecture, and data warehouse design. They will be responsible for designing, implementing, and optimizing our organization's data warehouse infrastructure to facilitate robust analytics and decision-making processes. Drawing upon their expertise in data engineering, they will spearhead the development of scalable data pipelines, ensuring seamless integration and processing of diverse datasets from various sources.
They will also be responsible for designing comprehensive data models and data systems architecture that align with our business objectives. This includes establishing data governance frameworks, defining data standards, and overseeing the implementation of best practices to ensure data integrity and security.
Responsibilities:
- Lead the design and architecture of our organization's data warehousing solutions together with the Director of the area, leveraging expertise in data architecture principles and best practices. They collaborate with stakeholders to define data models, schemas, and architecture patterns that optimize data storage, accessibility, and performance.
- Manage the data engineering in developing robust ETL and ELT processes for ingesting, processing, and transforming data from diverse sources into our data warehouse. They will ensure the reliability, scalability, and efficiency of ETL pipelines, employing technologies and tools such as Snowflake, Ribery, DBT, and SQL.
- Responsible for optimizing the performance of our data warehouse environment, identifying and resolving bottlenecks, and fine-tuning query performance.
- Establish data governance policies, oversee data quality initiatives, and implement data validation and cleansing processes to ensure the accuracy, completeness, and consistency of data stored in the data warehouse.
- Assess the scalability requirements of our data warehouse infrastructure and develop capacity planning strategies to accommodate future growth and expansion. They evaluate hardware and software options, design scalable architectures, and implement solutions that support increasing data volumes and user loads.
- Work closely with security teams to implement access controls, encryption mechanisms, and auditing procedures to protect sensitive data stored in the data warehouse. They ensure compliance with regulatory requirements such as GDPR, HIPAA, or SOC 2, implementing policies and procedures to safeguard data privacy and integrity.
- As the senior DW developer, they will provide leadership, guidance, and mentorship to data engineers, developers, and other team members. They will foster a culture of collaboration, innovation, and continuous learning, empowering team members to grow their skills and expertise in data warehousing technologies and practices.
- Partner with stakeholders to understand their data requirements, prioritize initiatives, and deliver solutions that meet business needs and objectives.
- Keeping abreast of emerging technologies and trends in data warehousing. Evaluate new tools, platforms, and methodologies, assessing their suitability for our data warehouse environment and recommending adoption strategies that align with our long-term goals and objectives.
- Drive a culture of continuous improvement and innovation. Seek opportunities to optimize processes, streamline workflows, and introduce innovative solutions that enhance the performance, reliability, and agility of our data warehouse environment, ultimately enabling our organization to derive maximum value from its data assets.
- Other duties as assigned.
Requirements:
- Bachelor's degree in Computer Science, Information Technology, or a related field.
- Minimum of 4 years of experience in data warehouse development and administration for on-premise and cloud data warehouse solutions.
- Extensive experience with Microsoft SQL Server, including proficiency in T-SQL scripting, stored procedures, and performance tuning.
- Hands-on experience with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
- Proficiency in Snowflake Data Warehouse, including designing data models, writing SQL queries, and optimizing performance.
- Experience with modern data transformation tools such as DBT (Data Build Tool) for cloud transformation.
- Experience training and transitioning on-premises resources to new cloud technologies.
- Proficient in using Rivery as an extraction tool for data ingestion and integration.
- Familiarity with cloud computing platforms such as AWS, Azure, or GCP.
- Excellent problem-solving skills and attention to detail.
- Strong communication and interpersonal skills, with the ability to effectively collaborate with cross-functional teams.
- Employee is required to have at minimum an internet speed of 75 Mbps (standard high-speed internet access).
Working Conditions:
- Flexibility to work in an office and/or at-home, remote office environment.
- Schedule flexibility is occasionally necessary in this position. Individual may be required to attend key business/departmental meetings and/or perform certain business critical job functions outside of normal working hours.
- Physical Demands: must be able to communicate internally and externally through receiving and responding to auditory and visual methods.
The starting pay for this role is $102,809 to $133,652 based on skill level and experience in a similar role.
This job description reflects management’s assignment of essential functions; it does not prescribe or restrict the tasks that may be assigned.
#J-18808-Ljbffr