LifeSource is hiring a Data Architect to be responsible for providing comprehensive technical solutions for data integration, data management, stewardship, and data quality for the organization, and provides expertise in the design, implementation and maintenance of the data warehouse and all related extraction, transformation, and load data functions.
This role will define data standards and principles and architecture for business intelligence and data warehouse, including developing and guiding data governance to ensure data integrity and compliance with relevant regulations. All activities will align with the strategic and operational goals of the organization, ensuring that data is effectively utilized to drive informed decision-making and business goals are supported.
As a Data Architect, you’ll advance our life-saving work by performing the following job duties:
Participating in defining a roadmap for technical assurance, data integration, and data governance related to the enterprise information architecture domain, translating business requirements into technology requirements. This includes:
- Deploying solutions for data principles including data management, stewardship, data quality standards, data integrity, and maximizing data use.
- Designing, configuring, and implementing effective database solutions, models, and data warehouse to store and retrieve company data for analysis, reporting, and dashboards meeting business standards.
- Defining the data architecture framework, standards, and principles, including modeling, metadata, security, reference data such as product codes and client categories, and master data such as clients, vendors, materials, and employees.
- Working across technology areas to identify and resolve complex issues related to the inter-dependencies between systems on major projects, providing expertise to design, develop, assess, and deploy architecture solutions for business problems in alignment with established standards.
- Completing analysis, reviewing, identifying patterns, forecasting and trending of LifeSource data for leadership, committees and other departments using a variety of software development languages and techniques.
- Overseeing the migration of data from legacy to new solutions and monitor the system performance through regular testing, troubleshooting, and integration of new features.
- Developing Tabular Models, Reports, dashboards, and additional analysis to meet business requirements.
- Complete data questions, data requests, data projects, and maintenance.
Managing ETL programs to facilitate the receipt of data from various data sources, loading of data into destination tables within the overall data architecture framework, designing end-to-end solutions for file creation and distribution, supporting ETL production processes and operations. This includes:
- Managing end-to-end data management including data integration, modeling, and reporting.
- Maintaining daily ETL processes, development and implementation of Microsoft SQLSERVER 2016 using SSIS, SSAS, SSRS and T-SQL using DDL, DML, and DCL commands.
- Performing performance tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
- Programming and developing SQL scripts, tables, views, stored procedures, functions, constraints, etc.
- Using SSIS (Integration Services) to move data into databases from various sources, executing data cleansing and transformations as needed.
Analyzing the business requirements for data file requests to design, develop, maintain, and deploy fully automated ETL jobs to produce data files using SSIS and the SSRS platform.
- Resolving SQL reporting services and T-SQL related issues.
- Using visual studio to develop ETL packages for enterprise data warehouse.
- Designing and automating data quality and data validation functions as part of the overall solution.
- Creating and deploying reports such as cross-tab, conditional, drill-down, top N, summary, form, OLAP and sub reports with relational and multidimensional data.
Participating in discussions with colleagues, customers, and stakeholders to understand and translate business use cases and requirements into data models, data integration routines, and analytics report findings. This includes:
- Communicating data results and analytics, educating others through design and build of insightful visualizations, reports, and presentations.
- Support effective training and education activities, competency, and understanding of data tools, resources, and information.
Influencing end user competency by supporting systematic process delivery tools and resources ensuring the development and maintenance of information services documentation. This includes:
- Recommending and implementing procedure and process modifications or improvements to current processes to ensure effectiveness and efficiency to support strategic direction plans.
- Collaborate and drive consistent documentation of comprehensive information services systems, including knowledge base articles, workflow, and network diagrams.
- Drive quality and consistency, engaging in root cause analysis, follow through, and timely documentation of all non-conformance and compliance reports.
- Engage as a subject matter expert, in ensuring successful internal, customer or regulatory audits.