Data Warehouse BA

2 weeks ago


Washington Dc, United States SBC Solutions Full time

NO C2C

VISA: USC

EXPERIENCE: 10 Years required

SKILLS/EXPERIENCE REQUIRED:

  • Minimum 7+ yrs. of relevant experience and master's degree plus required industry certificates; or bachelor's degree and 9+ years of relevant experience.
  • Experienced IT professional working on large data and reporting applications as well a strong understanding of Operational data stores, Data Warehouses and/or Data Marts.
  • Should have participated in data implementation efforts with exposure to relational database concepts, ETL fundamentals, transaction processing, and testing protocols.
  • Shows an understanding of data management concepts data quality, data lineage, data lifecycle, master/reference data management, metadata management.
  • Ability to understand the meaning of the data and work cohesively with business to leverage it for better and advanced insights. Domain knowledge with accounting and financial data sets is essential.
  • Has strong analytic, problem solving and logical reasoning skills with high attention to detail and the ability to multi-task.
  • Proficient in the use of PL/SQL and ability to read data models, infer data flows and write complex queries.
  • Experience with reporting tools (like Power BI, SAP BO, Tableau).
  • Excellent skills in analyzing data, gathering requirements, and working with clients and technical teams to translate requirements into solution.
  • Familiarity in using agile tools such as Azure DevOps.
  • Strong project management skills with a process orientation (understand problem, do analysis, interview stakeholders, write requirements, get sign off, hand off to dev, coordinate UAT etc.) and ability to leverage Agile concepts.
  • Excellent oral and written communications skills and experience interacting with both business and IT individuals.

The scope of work and activities include the following:

  • Capture data, reporting and analytic requirements for financial data sets which include Financial investment Operations Data, loan and equity accounting data sets, financial expenses and revenue data, treasury data and other financial data sets.
  • Perform data analysis, data lineage, and profiling of data from source system to data repositories and reports. Responsible for data mapping to any to-be data structures.
  • Create specifications for Reporting requirements and work with business users to elicit hidden requirements and clarify vague requirements, as well as ensure sign offs on requirements.
  • Interact with technical teams and guide offshore development resources to help translate requirements into solutions. Responsible for providing functional and technical guidance to the development team.
  • Coordinate user acceptance testing of reports and data driven solutions by working with the business users.
  • Assist the Program Managers with tracking work program deliverables using the appropriate SDLC methodologies including Agile Scrum.
  • Manage daily technical challenges and communicates to management any risks or issues.
  • Develop, manage, and maintain processes, procedures, and documentation for handover to application support.
Data Warehouse BA
  • Data Architect

    2 weeks ago


    Washington D.c., United States Prism, Inc. Full time

    Due to Federal Governement Security Clearance Requirements: U.S. Citizenship Do you have a passion for data and a knack for designing efficient systems? Are you an expert in data modeling and warehouse architecture? If so, then we want you on our team!We seek a highly skilled Data Warehouse Architect to design, develop, and implement our data warehouse...

  • Senior Data Engineer

    16 hours ago


    Washington D.C., United States Bates White Full time

    Bates White seeks a Senior Data Engineer in Washington, DC to design and develop ongoing data ingestion using Python and Spark. Support Requirements Gathering activities, especially from the data migration perspective. Use programming skills to create big data pipelines that can deal with both structured and unstructured data. Support other teams in...

  • BAS/EMCS Engineer

    1 month ago


    Washington, United States Ameresco Full time

    Job DescriptionJob DescriptionAmeresco has a new opportunity for a BAS/EMCS Engineer to join our Measurement & Verification Team. The engineer will be responsible for obtaining and analyzing data from building automation systems (BAS) and energy management control systems (EMCS) to evaluate the technical performance of energy efficiency and renewable energy...

  • BAS/EMCS Engineer

    2 months ago


    Washington, United States Ameresco Full time

    Job DescriptionJob DescriptionAmeresco has a new opportunity for a BAS/EMCS Engineer to join our Measurement & Verification Team. The engineer will be responsible for obtaining and analyzing data from building automation systems (BAS) and energy management control systems (EMCS) to evaluate the technical performance of energy efficiency and renewable energy...


  • Washington, United States Service Coordination, Inc. Full time

    Position Title: Enterprise Data Warehouse Developer Employment Status: Full-time Reports to: Enterprise Application Systems Manager FLSA Status: Exempt SCI Summary: SCI supports people with disabilities, behavioral challenges, medically complex needs, transitioning youth, the elderly, and other populations using Maryland Department of Health's Targeted Case...


  • Washington, United States Serigor Inc. Full time

    Job DescriptionJob DescriptionJob Title: Data Warehouse Developer-III (Remote)Location: Madison, WIDuration: 1+ MonthsJob Description:The client is looking for 1 Data Warehouse Developer IIIs.We have an immediate opening at the client for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we...


  • Washington, United States Serigor Inc Full time

    Location: Madison, WI Duration: 1+ Months Job Description: The client is looking for 1 Data Warehouse Developer IIIs. We have an immediate opening at the client for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven organization. This...

  • RCx/BAS Specialist

    1 hour ago


    Fort Washington, United States CM3 Building Solutions Full time

    Summary/Objective The RCx/BAS Specialist is a field technician performing Retro-commissioning services for building automation, building envelop, and mechanical systems. Essential Functions Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. Retro-commissioning: Provide Software project...


  • Washington, United States American Red Cross Full time

    By joining the American Red Cross you will touch millions of lives every year and experience the greatness of the human spirit at its best. Are you ready to be part of the world's largest humanitarian network? **** As a condition of employment with American Red Cross, you are required to provide proof that you are fully vaccinated for COVID 19 or qualify for...


  • Washington, United States Perfict Global, Inc. Full time

    About Us: Perfict Global is a leading IT consulting services provider focused on providing innovative and successful business workforce solutions to Fortune 500 companies. Our trained and experienced professionals constantly strive to bring together the best technologies available to manage client's complex business and technology, participate in...


  • Washington DC, United States Serigor Inc Full time

    Job Title: Location: Madison, WI Duration: 1+ Months Job Description: The client is looking for 1 Data Warehouse Developer IIIs. We have an immediate opening at the client for a strong Data Engineer to participate in our Data Management Program. Data is one of our most valuable assets and we strive to become a more data-literate and data-driven...


  • Washington D.C., United States Amgen Full time

    HOW MIGHT YOU DEFY IMAGINATION?If you feel like youre part of something bigger, its because you are. At Amgen, our shared missionto serve patientsdrives all that we do. It is key to our becoming one of the worlds leading biotechnology companies. We are global collaborators who achieve togetherresearching, manufacturing, and delivering ever-better products...

  • Warehouse Manager

    6 days ago


    Washington, United States Vascor Limited Full time

    ** VASCOR** ** Warehouse Manager** Georgetown, KY 40324 *Since its founding in 1987, **VASCOR** **(Value Added Service Corp.)** has logged millions of miles and handled millions of vehicles for a growing roster of global and regional clients. As one of the nation's most respected Third-Party Logistics (3PL) providers, we provide superior full-spectrum supply...


  • D.c., United States Spry Info Solutions Full time

    Hello,Hope you are doing good,We have a job opportunity for below position. If you are interested, please share updated resume.Job Title : Abinitio Developer with Big data Hadoop experienceLocation : DC, VA, MD and WVDuration : Long Term Note: 1) Need Independent Visa consultants on W2 and local to DC, VA, MD and WV 2) This position is with our Direct Client...

  • Warehouse Manager

    1 month ago


    Washington, United States Vascor Limited Full time

    ** VASCOR** ** Warehouse Manager** Georgetown, KY 40324 *Since its founding in 1987, **VASCOR** **(Value Added Service Corp.)** has logged millions of miles and handled millions of vehicles for a growing roster of global and regional clients. As one of the nation's most respected Third-Party Logistics (3PL) providers, we provide superior full-spectrum...

  • Data Engineer

    6 days ago


    Washington, United States POWERHOUSE INSTITUTE INC Full time

    Job DescriptionJob DescriptionData Engineer / ArchitectNOTE:   This is a full-time employment opportunity (No C2C, subcontractor or 1099 engagements, please).  The candidate MUST be a U.S. Citizen and have an active secret clearance (preferred) OR able to qualify/hold a secret clearance.  This is a remote opportunity with future possibility of becoming...


  • Washington, United States NTT DATA Full time

    Press Tab to Move to Skip to Content Link Select how often (in days) to receive an alert: Create Alert Apple MacOS Workspace ONE AirWatch Engineer Date: May 18, 2024 Location: Washington, DC, US Company: NTT DATA Services NTT DATA Services strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of...

  • Cloud Engineer

    2 weeks ago


    Washington D.c., United States Prism, Inc. Full time

    Due to Federal Governement Security Clearance Requirements: U.S. CitizenshipThis position is 100% on-site in Washington, DC. Must be local to DC, MD, VA Metro AreaPRISM seeks a highly skilled and experienced AWS Cloud Engineer to join our business intelligence development team. This mission-critical role will be vital in migrating our on-prem Oracle...


  • Washington, United States Halvik Full time

    Halvik is a highly successful company that puts people first, and we are looking for someone just like you. We are committed to delivering smarter IT-driven solutions bolstered by quality and innovation to help our customers succeed. Come be a part of something truly special! What You Will Do: This position will be responsible for serving as the primary data...


  • Washington D.C., United States Metropolitan Washington Airports Authority Full time

    Compensation Grade:T21Salary Range:$37.96-$49.35Opening Date:May 17, 2024Closing Date:June 1, 2024Please Note: All job announcements close at 11:59 p.m. of the day before the posted closing date.As an Industrial Controls Technician II, you will perform full journey level work in maintaining and troubleshooting all airport industrial control...