Data Warehouse Developer

Title:             Data Warehouse Developer

Standard Hours:    40

Primary Location:    Home Office (Remote)

Reports To:         Chief Information Technology Officer

Position Overview: 

As a Data Warehouse Developer, the core focus is the efficient integration, management, and delivery of data for decision-making purposes. This role will be responsible for designing, developing, and maintaining dimensional models, data pipelines, and reporting solutions. The ideal candidate will work closely with the data architect, software engineering team, business analysts, subject matter experts, and other stakeholders to design and implement solutions that meet business needs.

Primary Responsibilities (other related responsibilities may be necessary):

•    Data Modeling: Develop and manage dimensional data models using star schemas, snowflake schemas, and other structures to ensure data is well-organized and optimized for analytics.

•    Data Integration: Develop and manage pipelines to extract large volumes of data from various sources (e.g., transactional systems and flat files), transform it into a usable format, and efficiently load it into the data warehouse. Troubleshoot and resolve pipeline failures.

•    Data Analytics: Develop and manage recurring and ad-hoc data extracts, reports, and dashboards for consumption of both internal business users and external customers using a variety of tools and techniques. Troubleshoot data issues and work with cross-functional teams to resolve them.

•    Data Quality and Governance: Implement data validation rules to ensure the accuracy and completeness of data in the warehouse. Enforce data governance policies to maintain data integrity, security, and privacy. 

•    Data Security and Compliance: Enforce security measures to protect sensitive data. Ensure compliance with regulatory requirements related to data handling and privacy.

•    Documentation: Create and maintain process and architecture documentation including data dictionaries and source-to-target data mappings.

•    Warehouse Maintenance: Perform routine maintenance tasks to ensure the data warehouse runs smoothly. Automate recurring manual tasks. Monitor for bottlenecks and optimize pipelines, queries, and reports for high performance and scalability.

•    Warehouse Modernization: Assist in migrating a mature data warehouse built with on-prem technology to the cloud and merge with new data warehouse. Rebuild legacy data pipelines and reports using cloud technology. Design a new interactive reporting portal for both internal business users and external customers. 

Required Qualifications:

•    Bachelor’s degree in computer science or equivalent experience.

•    5+ years developing high quality enterprise-grade data warehouse systems using on-prem Microsoft BI tools:

o    SQL Server, 2014 and up

o    SQL Server Integration Services (SSIS)

o    SQL Server Reporting Services (SSRS) 

o    SQL Server Analysis Services (SSAS) Tabular, including strong DAX

•    2+ years developing cloud solutions utilizing Microsoft Azure Data Platform services including Azure Data Lake Store, Azure Storage, Azure Synapse, Azure Data Factory, Azure SQL database, Logic Apps, APIs.

•    T-SQL skills with the ability to create, understand, troubleshoot, and tune complex queries.

•    In-depth experience with data modeling and database optimization techniques.

•    In-depth experience with Power BI Desktop, Power Query, and semantic modeling.

•    Strong problem-solving skills with the ability to think critically and creatively. 

•    Strong attention to detail with the ability to multitask and meet deadlines.

•    Excellent communication skills with the ability to collaborate with both technical and non-technical stakeholders.

•    Desire and ability to stay abreast of the latest BI/DW technologies, trends, and techniques.

•    Team-player who exhibits professionalism, honesty, and integrity.

Preferred Qualifications:

•    Experience with Power Automate.

•    Experience with Power BI Report Builder.

•    Experience with Power BI Embedded.

•    Experience with Azure Synapse Analytics or Azure Databricks.

•    Experience with Microsoft Fabric.

•    Experience with automation tools and scripting languages (e.g., PowerShell, Python).

•    Experience working in a DevOps environment.

•    Experience with C#/.Net development.

•    Experience with student loans or other lending products.

•    Knowledge of agile methodologies.

Work Conditions: 

•    Sitting for extended periods of time. 

•    Dexterity of hands and fingers to operate a computer keyboard, mouse, and other devices. 

•    Physically and remotely able to participate in training sessions, presentations and meetings including video conferencing.

•    Some travel is required for the purpose of meeting with team members and management.

AA/EEO