• Be responsible for the development, maintenance, and enhancement of data modeling/extraction. 
• Guide best practices and provide knowledge transfer to other team members for ongoing support. 
• Plan and execute all required process steps throughout the development lifecycle. 
• Provide and own Data Warehouse application development support in assigned areas. 
• Analyze, design, code and test break/fix requests and enhancements to the Data Warehouse. 
• Review existing report design and development to make recommendations that improve efficiency and performance.
• Contribute to the growth of the Caboodle Data Warehouse by designing, developing and implementing Caboodle ETL processes
• Work with BI architects, developers, analysts and users to design, create and publish ETL processes and ETL metadata using CDW and SSIS ETL processes
• Work closely with other IT staff to meet expectations for design reviews and coding standards.
• Provide issue resolution during Quality Assurance/User testing.
• Troubleshoot and analyze ETL process failures, data anomalies and other ETL or data warehouse issues identified by automated monitoring, other developers and end users.

Skills: Data Modeling, ETL Development, Data Warehouse Support, Quality Assurance, Process Improvement, Coding Standards, Issue Resolution, Data Analysis

• Have expertise in relational and multidimensional database schemas. 
• Organize large analysis and design of large service cubes to design enterprise-level solutions for multidimensional databases
• Take responsibility for surfacing such sales and financial information in Jet Reports. 
• Design and build OLAP (online analytical processing) cubes. 
• Apply table logic and references, write queries, and design reports that will be provided to business units. 
• Deliver and receive feedback via Peer Code reviews. 
• Adhere to all company standards related to application development and architecture. 
• Proactively identify issues and act upon them by owning an issue to its resolution. 
• Troubleshoot/resolve complex problems, and equipment planning, procurement, configuration, and deployment. 
• Develop and facilitate training and/or establish and maintain procedures/documentation for supported products. 
• Work closely with sales reporting, finance, and operations lead.

Skills: Database Schema Design, OLAP Cube Development, Jet Reports Expertise, Query Writing, Peer Code Reviews, Application Development Standards, Issue Resolution, Training and Documentation

• Practice significant knowledge of data warehousing technologies and demonstrate expert knowledge in one or more ETL and ELT technologies
• Develop the open-source ETL tool Talend with the underlying PostgreSQL database Greenplum. 
• Understand database architectures as well as the implications of different database designs and data store technologies. 
• Understand the benefits of the various design methodologies and recognize system deficiencies and implement effective solutions. 
• Monitor the data warehouse system in all its aspects, respond and implement efficiency improvements. 
• Develop, implement, and maintain change control and testing processes for modifications to databases. 
• Develop and maintain relationships with internal client personnel by communicating effectively with them to identify needs 
• Evaluate alternative business solutions. 
• Be open to effective team interaction and acknowledge and appreciate each team member’s contributions. 
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures. 
• Conduct research and make recommendations on database products, services, protocols, and standards in support of procurement and development efforts. 

Skills: Data Warehousing Technologies, ETL Development, Database Architecture Understanding, Design Methodologies, Efficiency Monitoring, Change Control Processes, Client Relationship Management, Database Research and Recommendations

• Create star schema data models, perform ETL/ELT and validate results with business representatives
• Support implemented data solutions by monitoring and tuning queries and data loads, addressing user questions concerning data integrity, monitoring performance and communicating functional and technical issues
• Work closely with engineering teams to stay on top of any new workflows or features coming out and modeling the data for consumers
• Optimize current processes and develop new automation for data gathering, data pipelines, and ETL/ELT flows
• Design and implement ETL procedures (Azure Data Factory) for receiving data from internal and external sources and ensure that the data is verified, and quality checked
• Maintain and develop data marts, data objects and data models
• Guarantee data integrity, quality performance and resolution of data load errors
• Monitor, tune, analyze and report database performance including investigating and solving the causes of incompatibilities between applications that collect and use the company's data
• Discover new and creative ways to improve day-to-day business with a focus on efficiency and scalability
• Develop routines for end-users to facilitate best practices database use.

Skills: Star Schema Design, ETL/ELT Validation, Query Optimization, Data Pipeline Automation, Azure Data Factory Implementation, Data Mart Development, Data Integrity Assurance, Database Performance Monitoring

• Strong capabilities in Report design/information/database design skills
• High level of competence in all aspects of data visualization
• Responsible for leading the design, development and maintenance of data warehouse and analytics architecture to meet and enterprise’s business analysis and reporting needs
• Working with key stakeholders, architects and business partners to establish the technical vision for applications in customer data warehouses
• Gathering business requirements and creating architectural designs
• Designing, developing and supporting new and current processes employing industry standards and best practices
• Providing support to the business intelligence & data transformation team and supporting non-technical MI analysts
• Documentation of technical needs for processes ensuring optimal technical infrastructure is utilized
• Work as part of a team to review, analyze, modify, and create new processes including debugging, testing, functionality, integration and implementation
• Monitoring, tuning and performance analysis
• Administer the Microsoft development toolset including SQL Server Integration Services by performing maintenance and upgrades and supporting the development team in the use of these tools.

Skills: Report Design, Data Visualization, Data Warehouse Architecture, Business Requirements Gathering, Process Development, Business Intelligence Support, Technical Documentation, SQL Server Integration Services

• Consolidate and optimize organizational data warehouse infrastructure to ensure direction is provided to the BI activities.
• Deliver efficient and credible value across BI by monitoring and tuning data loads, data warehouse assets and optimization.
• Maintain all data warehouse architecture codes and documents in a version control system.
• Deliver data assets by designing and implementing Extract Transform and Load (ETL/ELT) procedures for the intake of data from internal and external sources.
• Promote a service-oriented approach by providing support to IT teams in all BI matters and relevant data training to business partners.
• Partner with stakeholders to consult on co-design and develop data marts, metadata, and data models, including logical and physical models.
• Contribute to the development of data stewardship principles by designing and implementing various unit tests, dashboards and data pipeline access through user-friendly tools for the business partners.
• Work closely with key members of the Primary Care Team in FRP to deliver the increasing demand for primary care data in a robust and timely manner
• Assist in the migration of processing data using cloud-based Primary Care technology to improve performance and availability.
• Work alongside other members of the Team to move processing from monthly to daily which will be challenging but will provide clients with the ability to work closely with GPs improving and influencing patient care planning.

Skills: Data Warehouse Optimization, ETL Procedures, Version Control, BI Support, Data Mart Development, Data Stewardship, Cloud Migration, Daily Processing

• Moderate experience in data warehousing process design, development, performance & tuning using the Informatica data warehousing tool suite
• Developing skills in the architecture of data warehouse and data integration strategies and solutions
• Knowledge of data warehouse best practice standards
• Knowledge in relational database technologies, e.g. Oracle, DB2, SQL Server
• Moderate skills in working with relational and dimensional data models
• Moderate skills working with slowly changing dimensions
• Strong data management and data analysis using SQL
• Strong verbal and written communication skills, including facilitation of meetings with customers and technical staff
• Knowledge and skills in the project development life cycle process (i.e., planning, analysis, design, coding, testing, implementation, and support)
• Demonstrated knowledge and skills in requirements gathering

Qualifications: BS in Information Technology with 5 years of Experience

• Strong Informatics/ETL experience, SQL Server experience (Version 2005 or higher)
• T- SQL experience, Visual Studio (Version 2005 or higher)
• SQL SSIS experience, and SQL & Querying Tuning.
• Experience working closely with business and IT stakeholders to define problems and design large-scale, enterprise-class solutions.
• Excellent communication skills both written and verbal.
• Experience working with SAP Business Objects.
• Knowledge of healthcare revenue cycle management.
• Experience gathering business requirements.
• Experience developing OLAP cubes for business intelligence applications and reporting.
• Expertise in working closely with business and IT stakeholders to define problems and design large-scale, enterprise-class solutions in a leadership role.

Qualifications: BS in Database Management with 4 years of Experience

• Hands-on/development experience with AWS Redshift
• Hands-on knowledge of Linux
• Hands-on knowledge of working in an AWS environment (Glue, Lambda, S3, EC2, RDS, Redshift, QuickSight)
• Hands-on knowledge of SQL Server and MongoDB, other database environments (e.g. Oracle, Snowflake)
• Hands-on knowledge of working with unstructured and structured data in different formats (Flatfile, JSON, XML, Parquet, etc.)
• Knowledge of working with a Customer Data Platform (e.g. Segment)
• Knowledge of working with a Data Integration tool (e.g. Informatica, AWS Glue) or other languages (Python, Java)
• Ability to work with stakeholders, understand detailed requirements, and then design DW tables and load processes
• Ability to take (constructive) feedback as a clarification of understanding and to redevelop with that in mind
• Be passionate about resolving data quality and data delivery pain points through great design

Qualifications: BS in Computer Science with 3 years of Experience

• Experience working in a Data Warehouse
• Previously worked within a Financial Service Organisation
• Strong T-SQL knowledge using SQL Server 2008/2012/2014 or later
• Expertise in SQL, ELT/ETL, reporting and Visual Analytics tools including SSMS, SSRS, SSIS
• Experience working in SQL, SQL Server
• The ability to design and implement Data Warehouse processes using Kimball methodology
• The ability to design and implement complex technical processes using Microsoft technologies
• Effective interpersonal relations skills, ability to effectively collaborate with others and work as part of a team
• Skills in navigating a large organization to accomplish results
• Ability to initiate and follow through on complex projects of both short and long-term duration

Qualifications: BS in Data Analytics with 2 years of Experience

• Data Warehouse and reporting-focused work experience
• Experience working in ETL/ELT development
• Experience in SQL query writing and optimization experience
• Experience with troubleshooting problems related to databases, software applications and servers
• Experience in business analysis and requirements gathering from business users
• Knowledge and understanding of data warehouse concepts (such as Kimball or Inmon methodologies)
• Ability to obtain, analyse and synthesize information from multiple sources
• Strong problem-solving skills with keen attention to detail and data quality
• Comfortable working in a fast-paced environment whilst interacting with a variety of different disciplines
• Proven ability to prioritize and deal with problems systematically and provide clear communications regarding the issues, resolution times and solutions

Qualifications: BS in Mathematics with 4 years of Experience

• Experience in data analysis, data cleansing, and data transformation (parsing, mapping, and serialization processes)
• Understanding of Data Warehousing and ETL/ELT techniques
• Experience with any ETL tools (preferably Talend)
• Experience/knowledge of Snowflake/Cloud DW
• Knowledge of scripting languages like Python or similar language
• Proficiency in SQL and Basic Linux system processing with shell scripting
• Experience and understanding of database architecture, and transformation tools
• Experience working with development teams, business teams, and database administrators, within an Agile methodology
• Strong communication and problem-solving skills
• Self-starter with proven ability and initiative to learn and research new concepts, ideas, and technologies

Qualifications: BS in Computer Engineering with 5 years of Experience