Job description
Under general supervision, the Sr. Data Warehouse Developer, develops and revises procedures to solve complex problems considering computer equipment capacity and limitations, operating time, and form of desired results. Prepares detailed specifications from which programs will be written. Competent to work at the highest technical level of all phases of applications systems analysis and programming activities. Responsible for ensuring standards and methodologies are followed.
Essential Duties and Responsibilities:
- Design, develop, document, and implement data mappings for ETL implementations, data modeling implementations, and real time data integrations (ETL) for OLTP and OLAP systems.
- Collects, analyzes, and interprets data to be used in program development to meet the defined user requirements.
- Prepares detailed specifications for programs of difficult complexity.
- Prepares development time estimates for assigned tasks and is responsible for meeting those estimates. Updates or creates technical and user documentation.
- Codes programs of difficult complexity, using recommended technologies. Follows the established methodologies and standards.
- Creates/Identifies test data to execute all functions of the coded programs. Executes program testing and is responsible for its accuracy and effectiveness.
- Develops and maintains technical efficiency in hardware/software and productivity tools and applies this knowledge to assignments.
- Ensures user requirements are met and development occurs according to design.
- Performs the analysis research and resolution of production program problems. Responsible for maintaining, debugging, and modifying these programs.
- Provides support on the Data Warehouse environment for system issues and participates in a rotation for off hours support with other members of the Data Warehouse team.
- Coordinates between other IT areas to maintain maximum efficiency of application systems. Collaborates with users to obtain feedback on effectiveness of the system.
- Regularly provides guidance and training to less experienced application analysts.
- May be responsible for completion of a phase of a Project.
Qualification
Qualifications - External
- Bachelor’s degree in Industrial Engineering, MIS, or directly related field required.
- Minimum 5 years of experience with SQL, Unix Linux and Windows scripting required.
- Minimum 5 years of experience with integration tools required. Experience with Datastage required.
- Working knowledge of one or more specified technologies required. Specified technologies may include Snowflake, Azure, Python, Java, MicroStrategy, Teradata, Datastage, Redwood, SQL.
- Strong oral and written communication skills required.
- Good understanding of the theories and principles of systems development and the interrelationships of systems required.
#LI-RG1
#HYBRID
gatheringourvoice.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, gatheringourvoice.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, gatheringourvoice.org is the ideal place to find your next job.