Data Warehouse BI Developer 2 (REMOTE)

Serigor Inc; Richmond (VA); Remote; USD 80,000 - 110,000; Full time

Job summary

A leading company is seeking a Data Warehouse BI Developer to join their remote team. The ideal candidate will have strong experience in Azure and ETL tools, contributing to data-driven decision-making. Responsibilities include designing and supporting data solutions in an Agile environment, ensuring effective data management practices.

Qualifications

• Minimum 3-5 years experience in data warehouse and BI solutions.
• Experience with cloud-based data platforms like Azure Synapse Analytics.

Responsibilities

• Design, develop, and support data-driven solutions.
• Lead the implementation of scalable data warehouse systems.

Skills

Azure

ETL

SQL

Data Governance

Agile

Communication

Education

Bachelor’s degree in Computer Science

Tools

Power BI

SSIS

Azure Data Factory

Job description

Job Title: Data Warehouse BI Developer 2 (REMOTE)
Location: Richmond, VA
Duration:12+ Months

Job Description:
The client is seeking an Azure Business Intelligence Developer with a minimum of 3-5 years’ experience to work with an existing software development team on an ongoing project.

• This position will work in an Agile/Scrum development environment with an existing data and analytics team to design, develop, test, and support solutions that enable data-driven decision-making across the agency.
• The candidate will lead and contribute to the design and implementation of scalable data warehouse and business intelligence systems, applying principles and techniques of data architecture, integration, and analytics.
• The position requires experience with cloud-native data warehousing platforms, ETL development, and a strong understanding of enterprise data management best practices.

Skills:

Skill	Required / Desired	Amount	of Experience
At least 3 years of hands-on experience designing, developing, and supporting enterprise data warehouse and business intelligence solutions.	Required	3	Years
Strong proficiency with ETL/ELT tools such as SQL Server Integration Services (SSIS) and Azure Data Factory	Required	3	Years
Experience working with cloud-based data platforms such as Azure Synapse Analytics or Microsoft Fabric.	Required	3	Years
Proficiency in SQL development, including writing complex queries, stored procedures, views, and optimizing performance for large datasets.	Required	3	Years
Experience building and maintaining star schema data models, fact and dimension tables, and metadata documentation.	Required	3	Years
Experience with data visualization and reporting tools, especially Power BI Service.	Required	3	Years
Strong understanding of data governance, quality, and lineage principles.	Required	3	Years
Experience integrating data from diverse structured and semi-structured sources including relational databases, flat files, APIs, and cloud storage.	Required	3	Years
Familiarity with source control and DevOps practices, including CI/CD pipelines for data integration workflows.	Required	3	Years
Strong analytical and troubleshooting skills for diagnosing data anomalies, ETL failures, and performance bottlenecks.	Required	3	Years
Demonstrated ability to collaborate with business stakeholders to translate requirements into technical specifications and data pipelines.	Required	3	Years
Strong communication skills, both written and verbal, for documenting data models, workflows, and data contracts.	Required	3	Years
Experience working in Agile/Scrum or DevOps environments.	Required	3	Years
Microsoft certifications such as Azure Data Engineer Associate (DP-203) or SQL Server certifications are highly desirable.	Required	3	Years
Bachelor’s degree in Computer Science, Information Systems, Data Science, or a related field is highly desirable.	Highly desired	3	Years