Sr Data Warehouse Developer

4 weeks ago


Richmond, United States Delphi-US Full time
Job Title: Data Warehouse Developer / Data Engineer (Contract) - Job#4252)

Location: Hybrid. Richmond, VA. 2 days onsite

Job Description:
This client is seeking resources with abilities to design, develop, modify, test and automate to provide data warehouse and business intelligence applications solutions. This includes design, development, architecture recommendations, quality management, metadata and repository creation, trouble-shooting problems and tuning warehouse applications. Develops transition and implementation plans. Recommends changes in development, maintenance and standards

Qualifications:
• Expert in developing and analyzing complex SQL on a variety of RDBMS (Microsoft SQL Server, Oracle)
• Expert knowledge of data modeling and understanding of different data structures and their benefits and limitations under particular use cases
• Experience with ETL tools (Informatica)
• Ability to create quality ERD's (entity-relationship diagrams)
• Excellent writing skills for writing user and system documentation
• AWS Cloud Data Warehousing Technologies
o Experience using core AWS services to build and support data warehouse solutions leveraging AWS architecture best practices (S3, DMS, Glue, Lambda)
o Development/modeling experience with Amazon Redshift
o Experience using the AWS service APIs, AWS CLI, and SDKs to build applications
o Proficiency in developing, deploying, and debugging cloud-based applications using AWS
o Ability to use a CI/CD pipeline to deploy applications on AWS (GitLab, Terraform, DBMaestro)
o Ability to apply a basic understanding of cloud-native applications to write code
o Proficiency writing code for serverless applications
o Ability to write code using AWS security best practices (e.g. encryption at rest and in transit)
o Ability to author, maintain, and debug code modules on AWS
• Experience with visualization tools (Tableau)
• Experience creating scripts with Python
• Experience working on an Agile team
• Understanding of application lifecycle management
• Understanding of the use of containers in the development process

Required Skills:
.• Advanced analytical ability and technical skill as well as the ability to provide innovative solutions to technical needs and business requirements
• Ability to exercise independent judgment in making complex business decisions
• Acute attention to detail with a high level of data integrity and accuracy
• Excellent oral and written communication, with interpersonal skills to work with people at all levels of the organization
• Ability to translate highly technical information into non-technical terms
• Excellent computer skills including Microsoft Office along with various other software applications as needed for the role
• Broad knowledge of the programming tools, concepts, practices, and principles including design, implementation, and testing
• Position requires continuous visual concentration and manual dexterity to operate PC
• Requires prolonged sitting and minimal standing/walking
• Minor lifting and carrying, not likely to exceed ten pounds
• Rare domestic travel including overnight stays may be necessary
• 5 to 9+ years of relevant work experience
• Bachelor's degree or equivalent experience

Responsibilities
• Contributes to the design, development, testing, implementation, and review of complex data warehouse and business intelligence solutions
• Develops all or part of complex data warehouse applications, develops software from established requirements, builds reports and dashboards, plans and coordinates work of lower level programmers to meet delivery commitments, creates prototypes; offers insight on the feasibility of system designs
• Contributes to the design of technology infrastructure and configurations, recommends process improvements
• Reviews complex patches and new versions of data warehouse applications. Implements complex software packages and deploys code
• Key participant in cross-functional team initiatives and process improvement projects
Comments/Special Instructions
  • Must be able to work on w2.
  • May require extended work hours and on-call status (15% or less).
About Delphi-US
Delphi-US is a national recruiting firm based in Newport, Rhode Island. We specialize in IT, Engineering and Professional Staffing services for organizations from Main Street to Wall Street. Our mission is simple: To connect great people to great companies. We accomplish this with a proprietary skill-based and cultural matching process that results in higher qualified submissions along with increased interviews and offer rates. You'll find our team is friendly, professional and ready to advocate on your behalf, armed with industry trends, and a dedication to client expectations.

  • Richmond, United States Kapital Data Corp Full time

    Title: Sr. Oracle Database DeveloperDuration: 12-24 monthsExperience: 8-10 yearsLocation: Richmond, VA *Local Richmond candidates or candidates willing to relocate to Richmond due to onsite work requirement*Candidates must be willing and able to work onsite 1-2 days/weekExperienced PL/SQL developer with skills in Oracle codingMust also have the ability to do...


  • Richmond, United States Ageatia Global Solutions Full time

    Designs, develops, modifies, tests and automation used to provide data warehouse and business intelligence applications solutions. This includes design, development, architecture recommendations, quality management, metadata and repository creation, trouble-shooting problems and tuning warehouse applications. Develops transition and implementation plans....

  • SR ETL Developer

    2 weeks ago


    Richmond, United States Crescens Full time

    Job Title: SR ETL Developer Location: Richmond, VA Duration: 8+months Type: Contract*Local Richmond, VA candidates ONLY required due to onsite requirement * *This position requires onsite 3 days a week with 2 remote * *Contractor will be responsible for purchasing parking through VDOT's Parking Management Office or procuring their own parking*Job...


  • Richmond, United States Crescens Full time

    Job Title: Data Warehouse/BI Developer Location: Richmond, VA Duration: 12 Months Job Description: Note: The effort will be a mix of onsite and remote work, with an initial assessment onsite, after which the hybrid arrangement would be defined. This effort could run at least 12 to 18 months and the onsite work would be at DPOR's offices at the beginning...


  • Richmond, United States Echo IT Solutions, Inc Full time

    Data Warehouse Architect Chesterfield, VA Candidate will be expected to create and modify Workday inbound and outbound interfaces. To manage these interfaces the candidate will need experience with Sql Server (SSIS) and Azure Data Factory pipelines. Ideal candidate will have extensive experience with Workday Studio and XSLT. Candidate could be creating data...


  • Richmond, United States Info Matrix Corp Full time

    Info-Matrix Corporation is currently seeking a skilled Data Warehouse Architect to join our team! POSITION SUMMARY: Candidate will be expected to create and modify Workday inbound and outbound interfaces. To manage these interfaces the candidate will need experience with Sql Server (SSIS) and Azure Data Factory pipelines. DUTIES AND RESPONSIBILITES: Creating...

  • Sr. Data Engineer

    2 weeks ago


    Richmond, United States Ampcus Full time

    Title: Sr. Data Engineer Location: Richmond, VA - 23238 - Hybrid Duration: 6 months assignment with the possibility of extension Responsibilities: Be a part of a team designing and building Enterprise Level scalable, low-latency, fault-tolerant data Pipelines that provide meaningful and timely insights Build the next generation of Distributed Data Pipelines...


  • Richmond, United States Info Matrix Corp Full time

    Info-Matrix Corporation is currently seeking a skilled Data Warehouse Architect to join our team! POSITION SUMMARY: Candidate will be expected to create and modify Workday inbound and outbound interfaces. To manage these interfaces the candidate will need experience with Sql Server (SSIS) and Azure Data Factory pipelines. DUTIES AND RESPONSIBILITES: ...


  • Richmond, United States Info Matrix Corp Full time

    Info-Matrix Corporation is currently seeking a skilled Data Warehouse Architect to join our team! POSITION SUMMARY: Candidate will be expected to create and modify Workday inbound and outbound interfaces. To manage these interfaces the candidate will need experience with Sql Server (SSIS) and Azure Data Factory pipelines. DUTIES AND RESPONSIBILITES: ...


  • Richmond, United States Crescens Full time

    Job Title: Senior Data Warehouse ArchitectLocation: Richmond, VADuration: 8 Months contract 2 Days ON SITE required each week. Local RVA candidates preferred OR (to be considered) must currently be within 3 hours drive of RVA, proof required of current residence required. Parking NOT available for contractors.ABOUT THE ROLE: DBHDS - Senior Data Warehouse...


  • Richmond, United States Crescens Full time

    Job Title: Data Warehouse Architect Location: Richmond, VA Duration: 16 months Note: *local Richmond, VA candidates required for onsite work *Candidates able to interview onsite. This is REQUIRED *candidate will be required to work ONSITE 3 days/wk, or additional days if requested. This is REQUIRED Job Description: Working with our business partners...


  • Richmond, United States V.L.S. Systems, Inc Full time

    Role: Sr PL/SQL Oracle DeveloperLocation: Hybrid | Richmond, VADuration: 12 MonthsInterview: Phone/Skype+F2F Sr Oracle Database Developer*Local Richmond candidates or candidates willing to relocate to Richmond due to onsite work requirement*Web Cam and ONSITE interviews *Candidates must be willing and able to work onsite 2 days/week for the first couple of...


  • Richmond, United States OP Consulting Group LLC Full time

    Position : Senior Oracle Database DeveloperLocation : Richmond,VADuration : 24+ Months Job Description Experienced PL/SQL developer with skills in Oracle coding Must also have ability to do data analysis, develop requirements and data models. Must have background in application backend support, Oracle PL/SQL and MS SQL server development. Must have...

  • Sr. Engineer Data

    4 days ago


    Richmond, United States CarMax Full time

    8116 - Midtown Office - 2220 W. Broad Street, Richmond, Virginia, 23220 CarMax, the way your career should be! What You Will Do – Essential Responsibilities Work collaboratively and creatively with other data engineers to develop scalable and maintainable data pipelines using the latest Microsoft Azure technologies and leading industry practices Develop...


  • Richmond, United States InfiCare Technologies Full time

    Position: Sr PL/SQL Oracle Developer Location: Richmond, VA (Hybrid Onsite) Mode: Contract (WX) *Experienced PL/SQL developer with skills in Oracle coding *Must also have ability to do data analysis, develop requirements and data models. *Must have background in application backend support, Oracle PL/SQL and MS SQL server development. *Must have background...


  • Richmond, United States HS Solutions Full time

    Role:- Sr Oracle Database DeveloperLocation:- 1401 E Broad St Richmond VA 23219 Job Description:-Local Richmond candidates or candidates willing to relocate to Richmond due to onsite work requirement *Web Cam and ONSITE interviews *Candidates must be willing and able to work onsite 2 days/week for the first couple of weeks, and 1-2 days/week...

  • Sr Java Developer

    2 weeks ago


    Richmond, United States Info High Tech LLC Full time

    Job DescriptionJob DescriptionBenefits:Competitive salaryFlexible scheduleOpportunity for advancement Please share Sr. Java Developer. Candidate must be local, In-Person Interview is requiredTitle: Sr. Java DeveloperStart Date: 06/03/2024End Date: 05/02/2025Location: 7700 Midlothian Turnpike, Richmond, VA 23235Interview type: In Person Only*candidate MUST be...


  • Richmond, United States Integrated Resources Full time

    Job Title: Sr Oracle Database Developer Location: Richmond, VA Duration: 24 Months (Possibilities of Extension). Local Richmond candidates or candidates willing to relocate to Richmond due to onsite work requirement. *Web Cam and ONSITE interviews *Candidates must be willing and able to work onsite 2 days/week for the first couple of weeks, and 1-2...


  • Richmond, United States Serigor Inc Full time

    Job Title: Sr Oracle Database Developer (HYBRID)Location: Richmond, VADuration:06 MonthsJob Description:Experienced PL/SQL developer with skills in Oracle codingMust also have ability to do data analysis, develop requirements and data models. Must have background in application backend support, Oracle PL/SQL and MS SQL server development. Must have...


  • Richmond, United States Serigor Inc Full time

    Job Title: Sr Oracle Database Developer (HYBRID) Location: Richmond, VA Duration: 06 Months Job Description: Experienced PL/SQL developer with skills in Oracle coding Must also have ability to do data analysis, develop requirements and data models. Must have background in application backend support, Oracle PL/SQL and MS SQL server development. Must have...