Data Architect
ROLE TITLE: Data architect with Finance & Accounting Data projects experience
LOCATION (HYBRID): Colorado Springs, CO; Lenexa, KS; Lubbock, TX; Purchase, NY; Topeka, KS
Role Summary
Data Developer/Engineer to design and build an accounting/finance data warehouse to extract and store data from upstream transaction systems, perform calculations on this data, and store the calculation results in the data warehouse. Validation and balancing routines must be created for data extracted from the upstream systems, and existing calculations in MS Excel must be ported to the data warehouse. Warehouse reports, and data extracts, are to be designed and implemented for use by the business units.
Role Responsibilities
Data architect with Finance & Accounting Data projects experience
Collaborate with the business teams to understand their current state and future state workflows and business/validation rules, existing MS Excel solution, data integration with external systems, and data warehouse reports to be designed and implemented.
Collaborate with various technical teams, and subject matter experts, to design and implement the future state data warehouse solution.
Collaborate with various technical teams and business units to ensure optimal performance of the data warehouse pipelines, calculations, and reports.
Work closely with the technical teams of the frontend applications to understand their data models and to build routines to extract, transform, and load data into the data warehouse.
Work closely with the business units to implement calculation routines.
Build validation and balancing routines to ensure that valid data is loaded to the data warehouse and that the data is accurately extracted and loaded.
Create test cases to validate that the warehouse data is being accurately extracted, validated, stored, and reported.
Create test cases to certify that the calculation routines are accurate.
Create test cases to measure and report on the performance of the data warehouse. Implement performance improvements, as necessary.
Collaborate with the Quality Assurance Team to create test cases and scripts for certifying the performance of the data warehouse and accuracy of the calculation routines, and that warehouse data is being accurately extracted, validated, stored, and reported.
Work with analytics and business teams on improving data models that feed business intelligence tools, increasing data accessibility, and fostering data-driven decision making across the organization.
Technical Qualifications
Strong knowledge of database design principles, database logical and physical design.
Minimum of 10 years professional experience designing and building accounting/finance data warehouses (insurance domain experience a plus).
Proficient in the following technologies: MS SQL SSIS, SSRS, MS Reporting Services and PowerBI).
Highly competent in performance tuning skills to ensure optimal performance of the data warehouse pipelines, calculations, and reports.
Able to demonstrate the ability to work effectively as a member of a team, as well as the maturity to work independently.
Possess excellent problem solving and troubleshooting skills.
Candidate is process oriented with great documentation skills.
Possess excellent oral and written communication skills.
LOCATION (HYBRID): Colorado Springs, CO; Lenexa, KS; Lubbock, TX; Purchase, NY; Topeka, KS
Role Summary
Data Developer/Engineer to design and build an accounting/finance data warehouse to extract and store data from upstream transaction systems, perform calculations on this data, and store the calculation results in the data warehouse. Validation and balancing routines must be created for data extracted from the upstream systems, and existing calculations in MS Excel must be ported to the data warehouse. Warehouse reports, and data extracts, are to be designed and implemented for use by the business units.
Role Responsibilities
Data architect with Finance & Accounting Data projects experience
Collaborate with the business teams to understand their current state and future state workflows and business/validation rules, existing MS Excel solution, data integration with external systems, and data warehouse reports to be designed and implemented.
Collaborate with various technical teams, and subject matter experts, to design and implement the future state data warehouse solution.
Collaborate with various technical teams and business units to ensure optimal performance of the data warehouse pipelines, calculations, and reports.
Work closely with the technical teams of the frontend applications to understand their data models and to build routines to extract, transform, and load data into the data warehouse.
Work closely with the business units to implement calculation routines.
Build validation and balancing routines to ensure that valid data is loaded to the data warehouse and that the data is accurately extracted and loaded.
Create test cases to validate that the warehouse data is being accurately extracted, validated, stored, and reported.
Create test cases to certify that the calculation routines are accurate.
Create test cases to measure and report on the performance of the data warehouse. Implement performance improvements, as necessary.
Collaborate with the Quality Assurance Team to create test cases and scripts for certifying the performance of the data warehouse and accuracy of the calculation routines, and that warehouse data is being accurately extracted, validated, stored, and reported.
Work with analytics and business teams on improving data models that feed business intelligence tools, increasing data accessibility, and fostering data-driven decision making across the organization.
Technical Qualifications
Strong knowledge of database design principles, database logical and physical design.
Minimum of 10 years professional experience designing and building accounting/finance data warehouses (insurance domain experience a plus).
Proficient in the following technologies: MS SQL SSIS, SSRS, MS Reporting Services and PowerBI).
Highly competent in performance tuning skills to ensure optimal performance of the data warehouse pipelines, calculations, and reports.
- Candidate has a proven track-record of collaborating successfully with subject matter experts, and various internal and external technical teams, during data warehouse implementation projects.
Able to demonstrate the ability to work effectively as a member of a team, as well as the maturity to work independently.
Possess excellent problem solving and troubleshooting skills.
Candidate is process oriented with great documentation skills.
Possess excellent oral and written communication skills.
-
Seniority level
Mid-Senior level -
Employment type
Full-time -
Job function
Engineering and Information Technology -
Industries
IT Services and IT Consulting
Referrals increase your chances of interviewing at EdgeGlobal LLC by 2x
See who you knowGet notified about new Data Architect jobs in Colorado Springs, CO.
Sign in to create job alertSimilar jobs
People also viewed
-
Information Technology Solutions Architect
Information Technology Solutions Architect
-
Solution Architect
Solution Architect
-
Cloud Architect
Cloud Architect
-
Java Architect -- Long Term Contract -- Remote
Java Architect -- Long Term Contract -- Remote
-
SENIOR ENTERPRISE ARCHITECT
SENIOR ENTERPRISE ARCHITECT
-
Director Enterprise Architecture
Director Enterprise Architecture
-
Chief Architect
Chief Architect
-
Solutions Architect
Solutions Architect
-
Workday Solutions Architect - NTRS - Chicago, IL
Workday Solutions Architect - NTRS - Chicago, IL
-
Data Center Architect - Remote
Data Center Architect - Remote
Looking for a job?
Visit the Career Advice Hub to see tips on interviewing and resume writing.
View Career Advice Hub