Remote Data Warehouse BI Developer 2 (REMOTE)

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.

Requirements:

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

Benefits:

• The position is contracted for a duration of 12+ months, providing stability for the duration of the project.
• The role is remote, offering flexibility in work location.
• The opportunity to work in an Agile/Scrum development environment, enhancing collaboration and innovation.
• The chance to lead and contribute to significant data-driven projects that impact decision-making across the agency.