Randstad Senior ETL Developer/ Data Steward in Chevy Chase, Maryland

Senior ETL Developer/ Data Steward


Chevy Chase, MD

Date Posted:

Tuesday, October 11, 2016

Job Type:


Reference #:



Randstad Technologies

apply now


Title: Sr. ETL Developer/Data Steward

Location: Chevy Chase, MD

Permanent opportunity/ Direct hire

Job Description:

The Senior ETL Developer/Data Steward will direct the long-term, strategic data needs for the organization and will develop conceptual, functional and virtualized models of enterprise data. He/She will support the Manager of Data Management in establishing an organizational data model design to facilitate data governance, data preparation, and data quality. He/She will work with team members to develop and implement robust, scalable data, analytics, reporting and custom solutions spanning multiple departments and integrated data requirements.

The incumbent will apply industry best practices to deliver data models and applications where the needs of the organization and the client are very specific. He/She will leverage systems such as MySQL, Oracle, SQL Server, and Vertica as well as SaaS solutions such as Workday ERP. He/She should be experienced in managing data elements from many sources inclusive of content and metadata. He/She will act as a quality gate keeper and represent IT in the area of master data quality assurance.

The Senior ETL Developer/Data Steward collaborates with and will provide guidance to data owners and data specialists. He/she will be a change agent in encouraging the use of standardized data processes. This resource is accountable for improving the data quality and consistency of critical data for both historical purposes and reuse in downstream applications or targets. He/she will be a key resource for the systems development process, including requirements definition, planning and executing development activities, adjusting priorities if necessary, and communicating status to management.


Data Warehouse

  • Implement the data architecture strategy, principles, standards, processes and tools in order to provide a data warehouse environment that supports IT strategies and enterprise project needs

  • Accountable for maintaining a data warehouse environment designed to support the organization for immediate projects and long-term sustainability

  • Develop and maintain data models/schemas for Enterprise and Investments data warehouses

  • Responsible for design, development, testing, deployment and ongoing operations of ETL processes

  • Enable and refine the data integration and data quality functions of the Data Strategy team

  • Continually assess the current state data warehouse environment and identify areas for improvement

  • Ensure data warehouse designs support high availability and disaster recovery capabilities

Data Management

  • Participate in data governance and data preparation for the organization s core source systems to ensure analytics, reporting and custom application requirements can be met

  • Serve as a technical resource for other members of the team in ensuring that data processing standards, guidelines and procedures are followed

  • Provide technical expertise and guidance to functional user community and thoroughly assess, analyze, troubleshoot, debug and resolve moderate to highly complex, high impact analytic and data management problems

  • Develop and maintain operational and system level documentation and train peers

  • Maintain knowledge of available technologies through reading, training, webinars, conferences, networking and collaboration to solve business problems

Project Management

  • Work with the PMO to support business process analysis activities and propose new or modified ways of addressing customer requirements

  • Manage projects, priorities and daily activities of staff members and several external consultants

Relationship Management

  • Develop a partnership and strong working relationship with stakeholder groups such as the ERP project team, HR, Finance and OGC to effectively collaborate on data governance for the organization

  • Interface regularly with the user community to understand their business needs

  • Work closely other IT teams to maintain excellent productive relationships

Required Skills:

  • Interpersonal skills such as flexibility, diplomacy, empathy and listening skills as well as excellent communication skills, both oral and written

  • Strong analytical and problem-solving skills

  • An orientation toward customer service and responsiveness

  • Strong organizational skills including the ability to manage multiple tasks simultaneously and to manage projects in a timely manner

  • Ability to motivate staff through effective leadership, mentoring, coaching, development, facilitation and effective evaluation

  • Commitment to personal development (technical and management capabilities) and staff development

  • Excellent problem solving and decision making skills to analyze data and reports, conduct research, develop plans, estimate effort, document and communicate information to others

  • Excellent judgment skills required due to possible use of confidential data

Required Experience:

  • Bachelor s degree in Computer Science, Information Systems, Business or related field

  • Graduate degree a plus

  • Extensive background in data management, data modeling, data analysis and ETL/integrations

  • Hands on experience in a Data Modeling role

  • Experienced with Oracle tools like Oracle Data Integrator (ODI) and Oracle Enterprise Metadata Management (OEMM)

  • Proficiency and hands on experience in Linux and Window s environment

  • Strong in PL/SQL, Linux/Unix Shell scripting, and programming skills like Python is a plus

  • Applied experience in MySQL, Oracle, SQL Server, Vertica and SaaS environments such as Workday ERP

  • Experience with data analysis, data profiling and data quality techniques, methodologies and tools

  • Deep knowledge base in master data management (MDM) and reference data management (RDM)

  • Capabilities in system analysis, design, development, testing, debugging, documentation, training, deployment, and post-production support

  • Expertise in architecting, designing, building, and configuring analytical reports and dashboards

  • Able to design, develop, test, implement, maintain and support custom application systems

  • Proven experience with data warehouses, data stores and data models

  • Strong understanding of data architecture standards and practices, as well as ETL development methodologies

    apply now