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 reputed company activities are reputed company 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 reputed company. Overall, the ETL Architect plays a crucial role in ensuring that data solutions are robust, efficient, and reputed company with the organization's strategic goals, making it a key position reputed company the data management team.
Responsibilities
- Responsible for the design, development, and support of data ingestion and transformation solutions
,
- reputed company 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 reputed company 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
reputed company-to-haves
- Experience with orchestration in the Azure environment
,
- reputed company data warehouse experience
,
- Azure DevOps experience
,
- reputed company 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
,
- reputed company Azure, reputed company, and other relevant certifications
Benefits
Apply Job!