Lead ETL Application Architect

1 week ago

Washington, Washington, D.C., United States Educology Solutions Full time
Job Overview

Salary:
Educology Solutions is in search of a Senior ETL Application Architect responsible for crafting and implementing processes that convert data from diverse origins to designated endpoints while effectively communicating insights to relevant stakeholders, clients, and partners. The role involves raising concerns to management, identifying best practices, and proposing enhancements to existing methodologies. This position also includes mentoring junior developers.

KEY RESPONSIBILITIES

· Primary Duties and Responsibilities

o Address complex ETL-related technical challenges, identify potential risks, resolve issues, and ensure tasks are completed successfully and on time.

o Comprehend processes and protocols, advocating for their application among all project participants both within and outside the ETL division.

o Guide team members in areas of expertise regarding ETL methodologies and standards, and engage in code evaluations.

o Notify management of project-related challenges; escalate issues promptly and seek assistance when necessary.

o Manage multiple assignments concurrently, prioritizing ETL tasks to guarantee timely completion.

o Design, test, oversee, and deploy ETL packages and applications adhering to the standards established by the team.

o Innovatively resolve intricate issues.

o Optimize and troubleshoot ETL applications.

o Conduct standard ETL administrative tasks such as deployment, package migration, and metadata management.

o Prepare ETL packages for deployment across development, testing, and production environments in accordance with all Release Management protocols.

o Automate processes where applicable.

o Participate in the on-call rotation.

REQUIRED SKILLS AND QUALIFICATIONS

o Proficient analytical skills in a SQL environment utilizing T-SQL.

o Knowledge of ETL design and development with the Microsoft BI toolset, particularly SSIS and T-SQL.

o Database expertise with the ability to query complex datasets.

o Exceptional verbal and written communication abilities.

o Commitment to adhere to organizational policies and values.

o Ability to maintain attendance to support the required quality and quantity of work.

o Uphold confidentiality and comply with the Health Insurance Portability and Accountability Act (HIPAA).

o Capability to establish and sustain positive and effective working relationships with colleagues, clients, members, providers, and customers.

EDUCATION REQUIREMENTS: Bachelor's Degree or equivalent experience.

EXPERIENCE REQUIREMENTS:

5+ years of experience in ETL design and development.

5+ years of experience in data analysis using SQL.

5+ years of database experience utilizing SSIS and T-SQL.

PREFERRED CERTIFICATIONS:

Microsoft Business Intelligence certification(s).


  • Lead ETL Application Architect

    1 week ago

    Washington, Washington, D.C., United States Educology Solutions Full time

    Job OverviewSalary: Educology Solutions is in search of a Senior ETL Application Architect who will play a pivotal role in the design and development of processes that convert data from diverse sources to various destinations, while effectively communicating insights to relevant stakeholders, clients, and partners. This position involves raising concerns to...

  • Lead ETL Application Architect

    1 week ago

    Washington, Washington, D.C., United States Educology Solutions Full time

    Job OverviewSalary: Educology Solutions is in search of a Senior ETL Application Architect who will play a pivotal role in crafting and implementing processes that convert data from diverse origins to designated targets, while effectively communicating insights to relevant stakeholders, clients, and partners. This position requires the escalation of concerns...

  • ETL Solutions Architect

    6 days ago

    Washington, Washington, D.C., United States SynOpt LLC Full time

    Job OverviewAt SynOpt LLC, we are seeking a highly skilled ETL Developer to join our team. As an ETL Developer, you will play a critical role in designing, implementing, and maintaining Extract Transform Load (ETL) solutions that drive business growth and success.Key ResponsibilitiesDesign and implement SAP Data Service jobs to extract, transform, and load...

  • Senior ETL Solutions Architect

    2 weeks ago

    Washington, Washington, D.C., United States Compass Solutions Full time

    Position Overview:We are seeking a highly skilled Senior ETL Solutions Architect with extensive experience in the design, development, and management of ETL processes. The ideal candidate will have a minimum of 10 years of professional experience in utilizing Informatica PowerCenter for creating efficient workflows and data mappings.Role...

  • Senior ETL Solutions Architect

    2 weeks ago

    Washington, Washington, D.C., United States Volitiion IIT Full time

    Job OverviewPosition: Senior ETL DeveloperRole Summary: The Senior ETL Developer is responsible for the design, development, and maintenance of reporting solutions and data integration processes. This role involves working with SSRS (SQL Server Reporting Services) and ETL (Extract, Transform, Load) methodologies to enhance reporting capabilities derived from...

  • Senior ETL Solutions Architect

    2 weeks ago

    Washington, Washington, D.C., United States Volitiion IIT Full time

    Job OverviewPosition: Senior ETL DeveloperRole Summary: The Senior ETL Developer is responsible for the design, development, and maintenance of data integration processes and reporting solutions. This role involves working with SSRS (SQL Server Reporting Services) and ETL (Extract, Transform, Load) methodologies to enhance reporting capabilities derived from...

  • Senior ETL Solutions Architect

    1 week ago

    Washington, Washington, D.C., United States Volitiion IIT Full time

    Job OverviewPosition: Senior ETL DeveloperRole Summary: The Senior ETL Developer is responsible for designing and implementing robust ETL processes and SSRS reports that enhance data usability and reporting capabilities. This role involves modernizing data workflows and ensuring the accuracy and integrity of data utilized in reporting and analytics.Key...

  • Data Transformation Expert

    6 days ago

    Washington, Washington, D.C., United States SynOpt LLC Full time

    Job OverviewAt SynOpt LLC, we are seeking a highly skilled ETL Developer to join our team. As an ETL Developer, you will play a critical role in designing, implementing, and maintaining Extract, Transform, and Load (ETL) solutions for our clients.Key ResponsibilitiesDesign and implement SAP Data Service jobs to extract, transform, and load data from source...

  • Lead ETL Administrator for Ab Initio

    2 weeks ago

    Washington, Washington, D.C., United States Excelon Solutions Full time

    Job OverviewExcelon Solutions is seeking a Lead ETL Administrator specializing in Ab Initio to join our innovative IT team. This role is designed for a professional with extensive experience in ETL administration and cloud technologies.Location: Remote options available, with preference for candidates familiar with hybrid work environments.Contract Duration:...

  • Senior ETL Solutions Developer

    1 week ago

    Washington, Washington, D.C., United States Go intellects Inc Full time

    Job OverviewBenefits:Attractive compensation packagePosition Summary:Brief Overview:An accomplished ETL Developer specializing in Informatica with over 10 years of extensive experience in designing, developing, testing, and managing Informatica PowerCenter workflows and mappings.Detailed Responsibilities:The primary responsibilities for this role include:1....

  • Senior ETL Engineer

    1 week ago

    Washington, Washington, D.C., United States Go intellects Inc Full time

    Job OverviewBenefits:Attractive compensation packagePosition Summary:Brief Overview:An accomplished ETL Developer with over a decade of extensive experience in the design, implementation, testing, and management of Informatica PowerCenter workflows and mappings.Detailed Responsibilities:The primary responsibilities for this role include:1. Designing data...

  • Senior Informatica ETL Developer

    2 weeks ago

    Washington, Washington, D.C., United States AHU Technologies Inc Full time

    Job DescriptionJob Summary:AHU Technologies Inc is seeking a highly skilled Senior Informatica ETL Developer to join our team. As a key member of our data integration team, you will be responsible for designing, implementing, and testing Informatica Powercenter Workflows and Mappings.Key Responsibilities:Create data mapping and workflows using Informatica...

  • Lead Systems Architect

    2 weeks ago

    Washington, Washington, D.C., United States Allen Integrated Solutions Full time

    Job OverviewPosition: Systems Architect (Expert)Clearance Level: TS/SCIExperience Required: 18 yearsLocation: Springfield, VA/ChantillyPosition Summary:As a leading Systems Architect, you will play a pivotal role in guiding the design and development of innovative solutions for intricate application challenges. This includes API design, data services,...

  • Cloud Application Engineering Architect

    2 weeks ago

    Washington, Washington, D.C., United States Booz Allen Hamilton Full time

    Position Overview:As a Cloud Application Architect, you will leverage your extensive experience in technology solutions to address complex challenges faced by our clients. Your ability to foresee potential issues and design effective systems will be critical in shaping the future of cloud technology.Your Role:In this position, you will be responsible for...

  • Lead Security Architect

    2 weeks ago

    Washington, Washington, D.C., United States Zachary Piper Full time

    Position Title: Lead Security ArchitectLocation: Washington, DCCompany: Zachary Piper SolutionsSecurity Clearance: Top Secret, SCI EligiblePosition Overview:Zachary Piper Solutions is seeking a Lead Security Architect to become a vital part of a dynamic team dedicated to supporting a government entity. This role necessitates 5 days in the office, situated in...

  • Lead Software Architect

    2 weeks ago

    Washington, Washington, D.C., United States Tetrad Digital Integrity LLC Full time

    Exciting Opportunity as a Lead Software Architect at Tetrad Digital Integrity (TDI)At Tetrad Digital Integrity (TDI), we are at the forefront of cybersecurity innovation, where teamwork, inclusivity, and creativity drive our mission. As a premier cybersecurity organization, we are dedicated to safeguarding our clients against digital vulnerabilities. Our...

  • Senior ETL Solutions Developer

    7 days ago

    Washington, Washington, D.C., United States Go intellects Inc Full time

    Job DescriptionBenefits:Competitive salaryPosition Overview:Brief Summary:We are seeking a highly skilled Informatica ETL Developer with over 10 years of extensive experience in the design, development, testing, and management of Informatica PowerCenter workflows and mappings.Detailed Responsibilities:The primary responsibilities of this role include:1....

  • Cloud Architect Lead

    5 days ago

    Washington, Washington, D.C., United States T-Rex Solutions Full time

    Job DescriptionT-Rex Solutions is seeking a highly skilled Cloud Architect Lead to design, deploy, and maintain secure and resilient cloud environments for the Department of Education.Key Responsibilities:Design cloud-based system architectures that incorporate public and private cloud technologies, software, hardware, and communications solutions to meet...

  • Senior Data Architect

    1 day ago

    Washington, Washington, D.C., United States Booz Allen Hamilton Full time

    About the RoleWe are seeking a highly skilled Senior Data Engineer to join our team at Booz Allen Hamilton. As a Senior Data Engineer, you will play a key role in the development and deployment of innovative big data platforms for advanced analytics and data processing.Key ResponsibilitiesMaintain responsibility for the maintenance, improvement, cleaning,...

  • Lead Project Architect

    2 weeks ago

    Washington, Washington, D.C., United States Cornerstone Development Group Full time

    Job OverviewA prominent Architectural Firm, focusing on diverse projects including mixed-use developments, multifamily housing, retail spaces, dining establishments, and residential designs, is in search of a Lead Project Architect dedicated to achieving design excellence. This role involves overseeing architectural projects that create significant and...