• Undertake a complete project through the entire SDLC of collecting requirements, recommending and designing a solution, creating project plans with realistic estimates, writing SSIS and Stored Procedures, Building Reports, Testing and Deploying relevant code.

• Responsible for moving data across multiple platforms using SSIS, familiar with high transaction driven applications, tuning complex SQL queries and building/maintaining SSRS reports and SSAS cubes.

• Conduct report design and development with Power BI.

• Develop ETL / ELT pipelines using source databases and REST services

• Coordinate development of ETL/ELT/data warehouse best practices needed to support new and evolving sources of data used in reporting, transaction processing and analytics

• Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts

• Conduct ETL / ELT performance tuning, troubleshooting, support and capacity

estimation

• Develop, adhere to, and be a proponent for Data Warehouse development standards,

including ETL / ELT standards and best practices

• Maintain a thorough understanding of business and ETL / ELT processes; identifying

efficiencies and needed controls to fine-tune ETL / ELT operations

• Provide documentation for all developed ETL / ELT processes, including process flow and

data mapping

• Solve business problems using one or more Azure Data and Analytics services in

combination with building data pipelines, data streams, and system integration.

• Maintain, design, and implement RESTful integrations with external and internal entities

• Develop audit reporting and quality improvement processes to ensure accurate and

consistent delivery of data

• Work closely with different internal and external teams to troubleshoot issues and help

them find a solution or design a suitable technical solution

• Serve as subject matter expert within the team and apply specialized knowledge to

support the organization's vision and direction

• Knowledge of Azure Data Factory, Azure Databricks, Azure AD, Azure ADDS, etc is

required.

Skills:

• Work with minimal supervision in an agile / DevOps environment, be an effective

communicator with other technology team members and business stakeholders

• Work with business leadership to understand problems and provide solutions

• Excellent verbal and written communication skills & experience writing both technical

and general documentation

• Strong organizational skills for developing the proper policies and procedures to

maintain and enforce quality data standards.

• The candidate must have strong analytical skills, he/she knows how to use technology to

maintain a high level of data accuracy throughout the project lifecycle

• Understand complex business and supply chain processes and how they tie with existing

customizations, modules, and integrations

• Ability to recommend improvements, plan future implementations, and build scalable

customizations