Data Architect

1 day ago

Colorado Springs, Colorado, United States United Software Group Full time
ROLE TITLE
Data Architect

LOCATION (HYBRID)

United Software Group is seeking a skilled Data Architect 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.

ROLE SUMMARY


The ideal candidate will have a strong understanding of database design principles, database logical and physical design, and a minimum of 10 years of professional experience designing and building accounting/finance data warehouses (insurance domain experience a plus).

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
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.

GENERAL QUALIFICATIONS


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.

EDUCATION REQUIREMENTS
Bachelor's degree in computer science, engineering, or a related field.
Data engineering certifications, considered a plus.

  • Data Architect

    1 day ago

    Colorado Springs, Colorado, United States Della Infotech Full time

    Job Title: Data ArchitectWe are seeking a highly skilled Data Architect to join our team at Della Infotech. As a Data Architect, you will be responsible for designing and implementing effective data architecture to support business intelligence and analytics reporting across Jefferson County, Colorado.The ideal candidate will have experience working with...

  • Data Architect

    3 weeks ago

    Colorado Springs, Colorado, United States Della Infotech Full time

    Job Title: Business Intelligence Architect/DeveloperWe are seeking an experienced Business Intelligence Architect/Developer to join our team at Della Infotech. As a key member of our Business Innovation & Technology department, you will play a crucial role in designing and implementing effective data architecture to support business intelligence and...

  • Enterprise Data Architect

    2 weeks ago

    Colorado Springs, Colorado, United States Creative Financial Staffing Full time

    Enterprise Data ArchitectAre you a seasoned data professional looking for a challenging role that leverages your expertise in data architecture, governance, and security? We have an exciting opportunity for an Enterprise Data Architect to join our team at Creative Financial Staffing.About the RoleThe Enterprise Data Architect will play a critical role in...

  • Enterprise Data Architect

    7 hours ago

    Colorado Springs, Colorado, United States Creative Financial Staffing Full time

    Enterprise Data ArchitectWe are seeking an experienced Enterprise Data Architect to join our team at Creative Financial Staffing. The ideal candidate will have a strong background in data architecture, data governance, and data modeling.The Enterprise Data Architect will be responsible for designing, creating, deploying, and managing data architecture to...

  • Enterprise Data Architect

    4 weeks ago

    Colorado Springs, Colorado, United States Creative Financial Staffing Full time

    Enterprise Data ArchitectAt Creative Financial Staffing, we're seeking an experienced Enterprise Data Architect to join our team. As a key member of our data analytics team, you will be responsible for designing, creating, deploying, and managing data architecture to meet or exceed various business strategies.About the RoleThe Enterprise Data Architect will...

  • SAP BI Data Architect

    2 weeks ago

    Colorado Springs, Colorado, United States United Software Group Full time

    Job Title: SAP BI Data ArchitectUnited Software Group is seeking a highly skilled SAP BI Data Architect to design and build an accounting/finance data warehouse. The ideal candidate will have a strong background in database design principles, database logical and physical design, and experience with MS SQL SSIS, SSRS, and PowerBI.Key...

  • Big Data Solutions Architect

    4 days ago

    Colorado Springs, Colorado, United States DISH Full time

    Job SummaryDISH is seeking a highly skilled Big Data Solutions Architect to join our team. As a key member of our Technology department, you will play a vital role in designing and implementing cutting-edge data solutions that drive business growth and innovation.Key ResponsibilitiesDesign and deploy enterprise-ready data solutions leveraging Data Warehouse,...

  • Senior Principal Engineer Systems Architect

    4 weeks ago

    Colorado Springs, Colorado, United States Northrop Grumman Full time

    Job Title: Senior Principal Engineer Systems Architect - Global Algorithm ArchitectNorthrop Grumman is seeking a highly skilled Senior Principal Engineer Systems Architect - Global Algorithm Architect to join our team of talented professionals. This role will be located in Colorado Springs, CO.Job Summary:The Command and Control, Battle Management, and...

  • Solutions Architect

    3 days ago

    Colorado Springs, Colorado, United States TechnoGen Full time

    Job DescriptionPosition: Solutions ArchitectLocation: RemoteClient: State of ColoradoNo calls only emailKey ResponsibilitiesBring best in class technologies, innovation, and creativity to the table in developing technical solutions to solve complex multi-dimensional problems.Perform a wide range of highly technical and advisory duties associated with the...

  • Data Architect

    1 month ago

    Colorado Springs, Colorado, United States Bayforce Full time

    Job Title: Senior Data EngineerJob Type: Contract/Contract to HireDuration: 4 months, potential for extensions and conversion to a FTELocation: Remote (Denver or Boulder, CO preferred for occasional onsite)About the Role:We are seeking a highly skilled Senior Data Engineer to join our team at Bayforce. As a Senior Data Engineer, you will be responsible for...

  • Data Architect

    5 days ago

    Colorado Springs, Colorado, United States Torch Technologies Full time

    Job Title: Data EngineerTorch Technologies is seeking a highly skilled Data Engineer to join our team. As a Data Engineer, you will be responsible for designing, building, and maintaining large-scale data processing systems to collect, store, and analyze data from various structured and unstructured sources.Job Responsibilities:Ensure data architecture meets...

  • Senior Principal Engineer Systems Architect

    4 weeks ago

    Colorado Springs, Colorado, United States Northrop Grumman Full time

    Job Title: Senior Principal Engineer Systems Architect - Global Algorithm ArchitectNorthrop Grumman is seeking a highly skilled Senior Principal Engineer Systems Architect - Global Algorithm Architect to join our team in Colorado Springs, CO. As a key member of our team, you will be responsible for developing and analyzing complex algorithms in support of...

  • Senior Principal Engineer Systems Architect

    5 days ago

    Colorado Springs, Colorado, United States Northrop Grumman Full time

    Job Title: Senior Principal Engineer Systems Architect - Global Algorithm ArchitectNorthrop Grumman is seeking a highly skilled Senior Principal Engineer Systems Architect - Global Algorithm Architect to join our team in Colorado Springs, CO.Job Summary:The Senior Principal Engineer Systems Architect - Global Algorithm Architect will be responsible for...

  • Senior Principal Engineer Systems Architect

    5 days ago

    Colorado Springs, Colorado, United States Northrop Grumman Full time

    Job Title: Senior Principal Engineer Systems Architect - Global Algorithm ArchitectNorthrop Grumman is seeking a highly skilled Senior Principal Engineer Systems Architect - Global Algorithm Architect to join our team of experts in Colorado Springs, CO.Job Summary:The successful candidate will provide technical expertise and support in developing and...

  • Principal Systems Architect

    5 days ago

    Colorado Springs, Colorado, United States Northrop Grumman Full time

    Job Title: Principal Systems ArchitectNorthrop Grumman is seeking a highly skilled Principal Systems Architect to join our team of experts in the field of missile defense systems. As a key member of our team, you will be responsible for developing and analyzing complex algorithms in support of new BMDS capabilities.Key Responsibilities:Provide technical...

  • Algorithm Architect

    5 days ago

    Colorado Springs, Colorado, United States Lockheed Martin Corporation Full time

    About the RoleWe are seeking a highly skilled Algorithm Architect to join our team at Lockheed Martin Corporation. As a key member of our Command, Control, Battle Management, and Communications (C2BMC) National Team, you will play a critical role in developing and integrating new capabilities for the Missile Defense System.Key ResponsibilitiesProvide...

  • Senior Principal Engineer Systems Architect

    4 days ago

    Colorado Springs, Colorado, United States Northrop Grumman Full time

    Job Title: Senior Principal Engineer Systems Architect - Global Algorithm ArchitectNorthrop Grumman is seeking a highly skilled Senior Principal Engineer Systems Architect - Global Algorithm Architect to join our team in Colorado Springs, CO.Job Summary:The successful candidate will provide technical expertise and support in developing and analyzing complex...

  • Application Architect

    1 week ago

    Colorado Springs, Colorado, United States H&R Block Full time

    Job Title: Application ArchitectWe are seeking an experienced Application Architect to join our team at H&R Block. As a key member of our technology organization, you will be responsible for defining the technology direction and architectural strategy for our Application Enterprise Architecture Domain.Key Responsibilities:Define and execute the architecture...

  • System Architect

    3 weeks ago

    Colorado Springs, Colorado, United States The Aerospace Corporation Full time

    System Architect Senior Member of Technical Staff - Systems EngineeringThe Aerospace Corporation is seeking a highly skilled System Architect to join our team. As a Senior Member of Technical Staff, you will be responsible for designing and developing system of systems and enterprise engineering MBSE models, including threat models and Blue capabilities in...

  • Platform Architect

    3 weeks ago

    Colorado Springs, Colorado, United States SAIC Full time

    Job Title: Platform ArchitectSAIC is seeking a highly skilled Platform Architect to join our team. As a Platform Architect, you will play a crucial role in designing and developing the core integration platform and roadmap for our project from end to end.Responsibilities:Design and develop the core integration platform and roadmap for our project from end to...