What are the responsibilities and job description for the Data Warehouse Specialist / ETL Developer position at Sara Software Systems?
This job was posted by https://www.kansasworks.com : For more
information, please see: https://www.kansasworks.com/jobs/13479249
data warehouse. Work collaboratively with key business users to
understand their information needs for building and enhancing the data
warehouse. Translate functional requirements into technical design
documents and develop ETL solutions which follow the software
development process and best practices. Perform data profiling of source
systems to assess data quality, integration risks, and metadata
discovery. Develop scalable ETL solutions with consideration to business
rules, fault-tolerance, and error logging. Develop ETL audits and
controls to ensure quality of data meets or exceeds standards defined by
business team. Estimate and plan work for all phases of the software
development lifecycle. Prepare unit and integration plans for different
ETL modules and execute the same. Design test plans to verify that all
developed solutions align with defined business requirements. Must
develop and communicate a technical vision that is easily understood by
all levels of management. Implement performance improvement techniques
such as data partitioning, data clustering, parallel processing, and
indexing to reduce response time for high volume tables. Conduct root
cause analysis for reported issues and identify impacted subject areas.
Account and handle various aspects of data warehouse maintenance such as
platform upgrades, data growth, data model revisions, and information
delivery enhancements. Effectively communicate and interact with other
technical personnel while solving complex business and technical
problems. Adhere to timelines during all phases of the software
development life cycle. Generate ad-hoc reports for end users by writing
complex SQL queries. Perform other duties as assigned by management. No
hire / fire authority. Multiple openings available.
information, please see: https://www.kansasworks.com/jobs/13479249
- Duties**: Build complex software models that extract data from
data warehouse. Work collaboratively with key business users to
understand their information needs for building and enhancing the data
warehouse. Translate functional requirements into technical design
documents and develop ETL solutions which follow the software
development process and best practices. Perform data profiling of source
systems to assess data quality, integration risks, and metadata
discovery. Develop scalable ETL solutions with consideration to business
rules, fault-tolerance, and error logging. Develop ETL audits and
controls to ensure quality of data meets or exceeds standards defined by
business team. Estimate and plan work for all phases of the software
development lifecycle. Prepare unit and integration plans for different
ETL modules and execute the same. Design test plans to verify that all
developed solutions align with defined business requirements. Must
develop and communicate a technical vision that is easily understood by
all levels of management. Implement performance improvement techniques
such as data partitioning, data clustering, parallel processing, and
indexing to reduce response time for high volume tables. Conduct root
cause analysis for reported issues and identify impacted subject areas.
Account and handle various aspects of data warehouse maintenance such as
platform upgrades, data growth, data model revisions, and information
delivery enhancements. Effectively communicate and interact with other
technical personnel while solving complex business and technical
problems. Adhere to timelines during all phases of the software
development life cycle. Generate ad-hoc reports for end users by writing
complex SQL queries. Perform other duties as assigned by management. No
hire / fire authority. Multiple openings available.