Remote ETL Architect

About the position

The ETL Architect is a pivotal role responsible for the design, development, and support of data ingestion and transformation solutions that are essential for reporting, analytics, and other applications. This position requires a deep understanding of ETL processes and the ability to construct technical designs that meet the needs of various stakeholders. The ETL Architect will engage in data analysis, create data models for peer review, and communicate effectively with team members and business stakeholders to ensure that the data solutions align with business objectives. Additionally, the role involves coordinating and reviewing the work of offshore development and support resources, ensuring that all activities are aligned with project goals and timelines. In this role, the ETL Architect will be responsible for a variety of tasks, including the design and development of data ingestion and transformation solutions, performing data analysis, and providing guidance to offshore support and development teams. The position also requires strong communication skills to facilitate collaboration with other BI team members, offshore teams, and cross-IT staff. The ETL Architect will assist in identifying tasks and estimating efforts for ETL development, as well as identifying risks and issues that may arise during the project lifecycle. Furthermore, the role may require providing off-hour and weekend support on a rotating basis, highlighting the need for flexibility and commitment to project success. Overall, the ETL Architect plays a crucial role in ensuring that data solutions are robust, efficient, and aligned with the organization's strategic goals, making it a key position within the data management team.

Responsibilities
? Responsible for the design, development, and support of data ingestion and transformation solutions
,
? Perform data analysis and create data models for peer review
,
? Provide guidance and direction to offshore support/development resources
,
? Communicate with other BI team members, offshore team members, and cross-IT staff on support and project activities
,
? Assist with task identification and effort estimates for ETL development
,
? Assist with risk and issue identification
,
? Provide off-hour/weekend support (on a rotating basis)
,
? Other projects or duties as assigned

Requirements
? Bachelor's Degree in Computer Science, Information Systems, or in a related discipline
,
? 4+ years of ETL development experience
,
? 2+ years of ETL design experience
,
? Design and development experience utilizing scheduling/automation tools preferably in the Azure environment
,
? Strong communication skills, including written and verbal communication skills
,
? Strong problem solving and analytical skills
,
? Strong ETL design skills
,
? Excellent ETL development skills utilizing an ETL tool, preferably utilizing Azure Data Factory
,
? Excellent SQL skills
,
? Strong understanding of Dimensional Modeling and other modeling techniques
,
? Strong understanding of SDLC best practices with an emphasis on DW/BI/Analytics practices
,
? This position must pass a post-offer background and drug test

Nice-to-haves
? Experience with orchestration in the Azure environment
,
? Snowflake data warehouse experience
,
? Azure DevOps experience
,
? GitHub experience
,
? MS Power BI experience
,
? Azure Blob Storage / ADLS experience with Data Storage, Analysis
,
? Data modeling experience
,
? Experience working with both structured and semi-structured data sources
,
? JavaScript and Python for stored procedures and scripting
,
? Experience leading offshore resources
,
? Microsoft Azure, Snowflake, and other relevant certifications

Benefits