Data ArchitectUnited Software Group • Colorado Springs, CO, United States
[error_messages.no_longer_accepting]
Data Architect
United Software Group • Colorado Springs, CO, United States
[job_card.variable_days_ago]
[job_preview.job_type]
- [job_card.full_time]
[job_card.job_description]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. Bachelor's degree in computer science, engineering, or a related field. Data engineering certifications, considered a plus.
ROLE TITLE
Data architect
LOCATION (HYBRID)
Colorado Springs, CO; Lenexa, KS; Lubbock, TX; Purchase, NY; Topeka, KS
Client
Sompo International
Rate
$80 / Hr
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
- 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
GENERAL QUALIFICATIONS
EDUCATION REQUIREMENTS
[job_alerts.create_a_job]
Data Architect • Colorado Springs, CO, United States
[internal_linking.similar_jobs]
All of the programs we support require.All work must be conducted within the continental U.Distributed Data Systems, Platforms at Scale, and Complex Application Development, with headquarters in Mc...[show_more]
Remote Lead Enterprise Architect (Colorado Springs).We are seeking a highly experienced.This individual will play a critical role in shaping our technology roadmap, leading architectural strategy, ...[show_more]
All of the programs we support require.All work must be conducted within the continental U.Distributed Data Systems, Platforms at Scale, and Complex Application Development, with headquarters in Mc...[show_more]
As a Solutions Architect at Slingshot, you will design innovative technical solutions to address unmet customer needs in the space-systems domain.
You'll play a key role in developing winning propos...[show_more]
This reputable Architecture and Design Firm is looking for a Project Architect to mentor, coach, develop and promote for long-term success.
This opportunity allows you the ability to take control of...[show_more] Join a well recognized, design-focused architecture firm with a decades-long track record of excellence and innovation! We are seeking a talented Licensed Architect / Project Architect to become an...[show_more] 
The Aerospace Corporation is the trusted partner to the nation's space programs, solving the hardest problems and providing unmatched technical expertise.
As the operator of a federally funded resea...[show_more]
System Architect and Information System Lead.Estimated Starting Salary Range : USD $174,950.Salary to be determined by the education, experience, knowledge, skills, and abilities of the applicant, i...[show_more]
If you are a first time user please create your candidatelogin account before you apply for a job.Click Sign In > Create Account).
If you already have a Candidate Account please Sign-In before yo...[show_more]
Salary : $140,000-$160,000 Depending on Experience.Acuity Innovations LLC is a smalldefense contracting company that provides enterprise architecture, solution design, digital engineering, defensive...[show_more]
We know these are some of the things people look for in a job.If you're the kind of person who believes that honoring and empowering our nation's veterans is more than just a cause - that it's a ca...[show_more]
All of the programs we support require.All work must be conducted within the continental U.Distributed Data Systems, Platforms at Scale, and Complex Application Development, with headquarters in Mc...[show_more]
Colorado Springs, CO Preferred, will consider remote work with some travel for the right candidate.Spry Squared is looking for a Principal Architect to coordinate the implementation of a DMZ at mil...[show_more]
We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of ...[show_more]
Peraton is seeking a Senior Database Architect to join our team supporting a large-scale national security credentialing system in a complex dynamic environment.
The candidate will design strategies...[show_more]
We are looking for a Software Lead who will be a member of the software architecture team on the Regional Applications Agile Release Train (ART).
Responsibilities will include defining and overseein...[show_more]
If your goal is to build a career that makes a difference and builds greater public confidence in good government consider joining the dedicated people of the State of Colorado.Our professionals st...[show_more] We are looking for a finance professional to join our team to train AI models.You will measure the progress of these AI chatbots, evaluate their logic, and solve problems to improve the quality of ...[show_more]
Cloud Services Architect
Raft • Colorado Springs, CO, United States
[job_card.full_time]
[last_updated.last_updated_1_day] • [promoted]
Remote Lead Enterprise Architect (Colorado Springs)
Infused Innovations • Colorado Springs, Colorado, United States, 80945
[filters.remote]
[job_card.full_time] +1
[last_updated.last_updated_30]
Data Engineer
Raft Company Website • Colorado Springs, Colorado, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Solutions Architect
Slingshot Aerospace • Colorado Springs, CO, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Project Architect
Gpac • Colorado Springs, Colorado, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Licensed Architect / Project Architect
Gpac • Colorado Springs, Colorado, United States
[job_card.full_time]
[filters_job_card.quick_apply]
[last_updated.last_updated_30]
Digital Transformation Architect
The Aerospace Corporation • Colorado Springs, CO, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
System Architect and Information System Lead
Scientific Research Corporation • Colorado Springs, CO, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Platform Architect
Broadcom • Colorado Springs, Colorado, USA
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Solution Architect (Enterprise Architecture & Modeling Focus)
Acuity Innovations • Colorado Springs, CO, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Enterprise Architect
Wounded Warrior Project • Colorado Springs, CO, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Cloud Services Architect
Raft Company Website • Colorado Springs, CO, US
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Principal Architect - Network
Spry Squared Inc • Colorado Springs, CO, US
[job_card.part_time]
[last_updated.last_updated_variable_days] • [promoted]
Remote FinTech Product Analyst - AI Trainer ($50-$60 / hour)
Data Annotation • Colorado Springs, Colorado
[filters.remote]
[job_card.full_time] +1
[last_updated.last_updated_30] • [promoted]
Senior Database Architect
Peraton • Colorado Springs, Colorado, USA
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Software Architect
Eliassen Group • Colorado Springs, CO, US
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
CDOC Architect I (Colorado Springs) EXTENDED
State of Colorado • Colorado Springs, Colorado, USA
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Remote Investment Analyst – AI Trainer ($50-$60 / hour)
Data Annotation • Colorado Springs, Colorado
[filters.remote]
[job_card.full_time] +1
[last_updated.last_updated_30] • [promoted]