Database Developer

компания "рекон групп" job description design, implement, and tune tables, queries, stored procedures, indexes in cloud data warehouse environment. develop and maintain enterprise-wide data models. serves as a data resource for organization. gathers and analyzes data in support of business cases, proposed projects, and systems requirements. design and develop dimensional models (star schema), data marts and design models for self-services analytics and reporting. collaborates with both internal and external teams to identify and validate data structures and fields along with defining build requests for new reports. identifies, determines and data mines multiple data sources (data lake, dw, oltp, nosql systems) to sеlесtstatically valid data samples; and tests builds, designs, develops, and implements query models, reporting tools, and database applications by investigating appropriate methods and algorithms. prepares reports for programs, management, and various requirements on a timely basis. supports the preparation and evaluation of special projects. utilize etl data methods (extraction, transform, and loading) to bring disparate data sources together into the correct format required by applications. reviews data for quality assurance discrepancies and communicate issues to supervisor and affected staff as needed. provide support for reporting issues or failures at any time. design and implement the ods data platform required for optimal extraction, transformation, and loading of data from a wide variety of data sources create and maintain optimal data pipeline architecture capable of ingesting structured and unstructured data in near real-time assemble large, complex data sets that meet functional and technical requirements identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, redesigning infrastructure for greater scalability, etc. implement data control and exception handling including data reconciliation work with stakeholders including the business analytics teams and application architecture teams to assist with data-related technical issues and support their data infrastructure needs work with geographically dispersed teams, embracing agile and devops strategies for themselves and others while driving adoption to enable greater technology and business value core responsibilities design, implement, tune tables, queries, stored procedures, and indexes in cloud data warehouse environment. develop and maintain enterprise-wide data models. serves as a data resource for the organization. gathers and analyzes data in support of business cases, proposed projects, and systems requirements. design and develop dimensional models (star schema), data marts and collaborates with both internal and external teams to identify and validate data structures and fields along with defining build requests for new reports. prepares reports for programs, management, and various requirements on a timely basis. utilize etl data methods (extraction, transform, and loading) to bring disparate data sources together into the correct format required by applications. reviews data for quality assurance discrepancies and communicate issues to supervisor and affected staff as needed. provide support for reporting issues or failures at any time. skills-requirements advanced working sql knowledge and experience working with relational databases, query authoring (sql), as well as experience with complex stored procedures for data processing. advanced data modeling skills of both olap and oltp databases experience performing sql performance tuning and optimization experience building large scale operational data stores in oracle, ms sql server or equivalent relational database experience with big data warehouses (mpp) is a plus. 5+ years of hands-on experience in data modeling, model-driven engineering, and design patterns 2+ years of hands-on experience in data lakes and data warehousing, messaging, distributed data architectures, and establishing data platforms to support complex analytical usage, including operational ml use cases