Azure Data Warehouse Developer (PA Local Only)

Required skill: • Significant, hands-on technical experience and expertise with the design, implementation and maintenance of business intelligence and data warehouse solutions, with expertise in using SQL Server and Azure Synapse. • Experience producing ETL/ELT using SQL Server Integration Services and other tools. • Experience with SQL Server, T-SQL, scripts, queries. • Experience as an Azure DevOps CI/CD Pipeline Release Manager who can design, implement, and maintain robust and scalable CI/CD pipelines, automate the build, test, and deployment processes for various applications and services, troubleshoot and resolve pipeline issues and bottlenecks, and has experience with Monorepo-based CI/CD pipelines • Experience with data formatting, capture, search, retrieval, extraction, classification, quality control, cleansing, and information filtering techniques. • Experience with data mining architecture, modeling standards, reporting and data analysis methodologies. • Experience with data engineering, database file systems optimization, APIs, and analytics as a service. • Analyzing and translating business requirements and use cases into optimized designs and developing sound solutions. • Advanced knowledge of relational databases, dimensional databases, entity relationships, data warehousing, facts, dimensions, and star schema concepts and terminology. • Creates and maintains technical documentation, diagrams, flowcharts, instructions, manuals, test plans, and test cases. Follows established SDLC best practices, documents code and participates in peer code reviews. • Ability to balance work between multiple projects and possess good organizational skills, with minimal or no direct supervision. • Demonstrated ability to communicate and document clearly and concisely • Ability to work collaboratively and effectively with colleagues as a member of a team. • Ability to present complex technical concepts and data to a varied audience effectively. • More than 5 years of relevant experience. • 4-year college degree in computer science or related field with advanced study preferred.