Data Integration and Warehouse Developer

4 weeks ago


Arlington, United States Association Analytics Full time

OVERVIEW

The Data Integration and Warehouse Developer designs, develops, tests and maintains Extract, Transform, and Load (ETL) processes. The Senior Data Integration and Warehouse Developer also documents, develops, and manages the creation of logical and physical data models. Additionally, technical expertise is applied to the design, development, and support of processing data of multiple databases and data formats involving both internal and external sources and targets. Highly tuned and efficient code, high levels of data quality and delivery excellence, effective and proactive verbal and written communication, excellence in customer service and partnerships, and teamwork are key success factors for this senior role.

AREAS OF RESPONSIBILITY

* Design, develop, test, and production support maintenance of data management and integration processes serving a highly visible, enterprise level customer base.

* Apply initiation and leadership skills with analysts, business owners, and end users to define and document business, technical, financial, and operational support requirements.

* Translate business requirements into technical solutions, dealing well with ambiguity, and concluding how deliverables meet business goals. Perform data analysis and data modelling to create source to target mapping documents. Perform data profiling as one means to output proof of high levels of data quality.

* Create, publish, distribute, and present design documents and other documentation, including logical or physical data models, end-to-end data integration diagrams, and Service Level Expectation documents.

* Develop effective error handling, perform unit testing, and gain stakeholder acceptance as key implementation and production support readiness criteria.

* Effectively balances and prioritizes workloads among project work development, support maintenance and operations (including on-call rotation), innovation and creativity, and initiative in a proactive, continuous improvement environment.

* Completes complex work assignments independently, takes initiative to flush out gaps in requirements or hopeful business outcomes, documents and confirms key understandings, and produces products with extremely low production support footprints.

* Performs consistently as a team player who shares knowledge, maintains effective working relationships, and puts yourself in service to othersmaintaining extremely high customer service levels.

* Contributes to the development of team process and technical standards, including the creation of reusable code base, highly efficient job scheduling and batch performance, service management excellence, and financial improvements.

* As a continuous improvement environment, always seeks to learn, test, and incorporate new methods at any phase of the delivery and service management lifecycle.

REQUIREMENTS AND EXPERIENCE

* Bachelors Degree in related field or a minimum of six years progressively related experience.

* 6+ years of ETL and SQL development experience with commercial ETL tools or development languages such as Python.

* 6+ years of experience delivering data quality outcomes, performing and presenting data profiling results, working with relational databases and a multitude of file formats.

* 6+ years of experience using technical expertise to engage customers and recommend and deliver lean, cost-effective solutions.

* 6+ years of experience with logical and physical data modelling.

* 6+ years of experience with data warehouse design and methodologies, including change data capture, star schemas, snowflakes, cubes and dimensional modeling.

* Demonstrated excellence using logical, analytical, and creative problem-solving skills.

* Excellent influence skills, using written and oral communication skills-including the ability to communicate ideas in both technical and business terms.

* Proven ability to conduct root cause analysis and research into systems and data issues.

PREFERRED SKILLS

* Experience with Project Management tools and best practices; Jira suite preferred

* Previous experience working with membership organization preferred

* Strong project management knowledge, with excellent grasp of program management methodologies including project risk management.

* Excellent analytical, organizational and problem-solving skills, as well as a demonstrated ability to simultaneously control numerous projects.

* Capacity to anticipate, comprehend and manage project dependencies across other initiatives in the organization.

* Must be collaborative in nature, utilizing exceptional listening and facilitation skills to build effective teams, drive effective outcomes and develop innovative solutions.

* Self-starter and ability to thrive in a fast-paced start-up environment

This position qualifies for remote work. In addition to adhering to all A2 policies, guidelines, procedures, and the Code of Conduct, it is the expectation the following requirements of the remote work policy will be met, including but not limited to:

* Remote workspace that is clean, safe, and professional.

* Maintains an internet connection consistent with A2 standards at remote workspace.

* Remain productive and responsive during their scheduled work hours.

* Attend primary A2 location, as needed.


  • Integration SME

    13 hours ago


    Arlington, United States ECS Limited Full time

    ECS is seeking an Integration SME / Developer to work in our Arlington, VA office (hybrid).Please Note: This position is contingent upon contract award. Job Description: ECS is seeking talented professionals who love a challenge to join us in building the next-generation Continuous Diagnostics and Mitigation (CDM) Cyber data solution. The CDM Program is the...


  • Arlington, United States Capital Impact Partners Full time

    Job DescriptionJob DescriptionAbout the Organization The Momentus Capital branded family of organizations - which includes Capital Impact Partners, CDC Small Business Finance, and Ventures Lending Technologies - is transforming how capital and investments flow into communities to provide people access to the capital and opportunities they deserve. We are...


  • Arlington, United States Amazon Data Services, Inc. Full time

    AWS Infrastructure Services owns the design, planning, delivery, and operation of all AWS global infrastructure. In other words, we’re the people who keep the cloud running. We support all AWS data centers and all of the servers, storage, networking, power, and cooling equipment that ensure our customers have continual access to the innovation they rely...


  • Arlington, United States Latitude, Inc. Full time

    Job DescriptionJob DescriptionWe are seeking a skilled AWS Data Engineer to join our team and contribute to the design, development, and implementation of robust data solutions on the AWS platform. As a Data Engineer, you will work closely with cross-functional teams to understand data requirements, architect data pipelines, and ensure efficient data...


  • Arlington, United States Latitude, Inc. Full time

    Job DescriptionJob DescriptionWe are seeking a skilled AWS Data Engineer to join our team and contribute to the design, development, and implementation of robust data solutions on the AWS platform. As a Data Engineer, you will work closely with cross-functional teams to understand data requirements, architect data pipelines, and ensure efficient data...

  • Data Architect

    3 weeks ago


    Arlington, United States CTC Full time

    Job DescriptionJob DescriptionComputer Technologies Consultants (CTC) is seeking a Data Architect to support the US Department of State in Arlington, VA. This position is telework eligible.With offices in Washington DC and San Diego, CA, CTC is a leading technology company providing lifecycle IT, data analytics, cloud managed hosting services, agile software...


  • Arlington, United States Lovelytics Full time

    Job DescriptionJob DescriptionWe are seeking an accomplished Principal Consultant with specialized expertise in delivering strategic Databricks and data engineering solutions for our clients at Lovelytics. As a pivotal member of our team, you will serve as a data and analytics solution architect, leading technical engagement and architecture initiatives...

  • Integration Engineer

    2 weeks ago


    Arlington, United States Shift5 Full time

    At Shift5, a rapidly expanding cybersecurity and operational technology firm, we excel in data collection, translation, transformation, and distillation. Our mission extends beyond providing advanced cyber defense; we are dedicated to enhancing mission readiness and preventative maintenance for a wide array of operational systems. Our expertise lies in...

  • Data Architect

    4 weeks ago


    Arlington, United States Computer Technologies Consultants, Inc. (CTC) Full time

    Computer Technologies Consultants (CTC) is seeking a Data Architect to support the US Department of State in Arlington, VA. This position is telework eligible. With offices in Washington DC and San Diego, CA, CTC is a leading technology company providing lifecycle IT, data analytics, cloud managed hosting services, agile software development, DevOps, Test...

  • Warehouse Manager

    4 weeks ago


    Arlington, United States B+T Group Full time

    Warehouse Manager Arlington, TX Small Cell Description **B+T Group:** It is our privilege to work with the premier companies in the wireless industry, and our goal is to do everything within our capabilities to contribute to their success. As this rapidly growing industry encounters new challenges in operational efficiency, our clients know they can depend...

  • Data modeler

    1 week ago


    Arlington, United States Soft source inc Full time

    Job DescriptionJob Description ****Data modeler**** ***12 months contract*******100% REMOTE**** *** EST HOURS****Data modeler, strong exp data modeling, Microsoft house, ETL Top 3 must haves: come in with the best candidate. Previous enterprise data warehouse experience, 3rd normal form, 5 plus years of experience. Need to have sql skills. Good sql,...


  • Arlington, United States Guidehouse Full time

    What You Will Do: Conduct interviews with client stakeholders to assess current metadata management and data governance capabilities and refine use cases associated with metadata management, taxonomy, and ontology development. Translate these use cases into requirements to communicate to the technical implementation team to implement into Collibra....


  • Arlington, United States Guidehouse Full time

    What You Will Do:Conduct interviews with client stakeholders to assess current metadata management and data governance capabilities and refine use cases associated with metadata management, taxonomy, and ontology development.Translate these use cases into requirements to communicate to the technical implementation team to implement into Collibra.Collaborate...


  • Arlington, United States Guidehouse Full time

    What You Will Do:Conduct interviews with client stakeholders to assess current metadata management and data governance capabilities and refine use cases associated with metadata management, taxonomy, and ontology development.Translate these use cases into requirements to communicate to the technical implementation team to implement into Collibra.Collaborate...

  • Integration Lead

    3 weeks ago


    Arlington, United States ECS Full time

    ECS is seeking an Integration Lead / Manager to work in our Arlington, VA office. Please Note: This position is contingent upon contract award.Job Description: ECS is seeking talented professionals to join our successful and growing team in building the next-generation Continuous Diagnostics and Mitigation (CDM) Cyber data solution. The CDM Program is the...


  • Arlington, United States Gaia Flooring, Inc. Full time

    Job DescriptionJob Description**Gaia Flooring has an opportunity for a Warehouse Associate/Delivery Driver, apply now!**Schedule: Monday - Friday 7:30 am - 4 pmPay Rate: $16 - $20 hourlyLocation: 3101 E Randol Mill Rd, Arlington TX 76011Gaia Flooring is a young and rapidly growing company that specializes in the production and distribution of industry...


  • Arlington, United States Gaia Flooring, Inc. Full time

    Job DescriptionJob Description**Gaia Flooring has an opportunity for a Warehouse Associate/Delivery Driver, apply now!**Schedule: Monday - Friday 7:30 am - 4 pmPay Rate: $16 - $20 hourlyLocation: 3101 E Randol Mill Rd, Arlington TX 76011Gaia Flooring is a young and rapidly growing company that specializes in the production and distribution of industry...


  • Arlington, United States Gaia Flooring, Inc. Full time

    **Gaia Flooring has an opportunity for a Warehouse Associate/Delivery Driver, apply now!**Schedule: Monday - Friday 7:30 am - 4 pmPay Rate: $16 - $20 hourlyLocation: 3101 E Randol Mill Rd, Arlington TX 76011Gaia Flooring is a young and rapidly growing company that specializes in the production and distribution of industry leading flooring. We are seeking a...

  • Integration Manager

    1 week ago


    Arlington, United States CMRG Full time

    Headquartered in Arlington, Virginia, our client – the nation’s largest deposit allocation service provider and the inventor of reciprocal deposits – provides dynamic, all-weather balance sheet and liquidity management solutions to help financial institutions grow franchise value. They are currently hiring an IT Integration Analyst for a hybrid role in...

  • Integration Manager

    1 week ago


    Arlington, United States CMRG Full time

    Headquartered in Arlington, Virginia, our client – the nation’s largest deposit allocation service provider and the inventor of reciprocal deposits – provides dynamic, all-weather balance sheet and liquidity management solutions to help financial institutions grow franchise value. They are currently hiring an IT Integration Analyst for a hybrid role in...