IT Solutions Architect

CommonSpirit Health; Englewood (CO); Remote; USD 100,000 - 130,000; Full time

Job summary

CommonSpirit Health is seeking a Solution Architect based in Englewood, Colorado. In this role, you will design, develop, and implement applications and solutions while ensuring reliable and scalable systems. You will lead cross-functional teams and provide technical oversight for various projects.

The ideal candidate should have 8-10 years of experience in ETL automation, data management, and leading teams in a collaborative environment. This position offers remote eligibility and requires a Bachelor's degree in Computer Science or a related field.

Qualifications

• 8-10 years experience with ETL automation and data management.
• 5 years experience leading teams on data management projects.
• Proficient with data management platforms and technologies.

Responsibilities

• Architect, design, and implement applications and solutions.
• Develop and ensure adherence to standards for all components.
• Coordinate cross-team dependencies and maintain ETL environments.

Skills

ETL automation

Data management

Database management systems

Service Bus Architecture

Education

Bachelor's degree in Computer Science or related field

Tools

SSIS

SSAS

Informatica

Job description

Job Summary and Responsibilities

As a Solution Architect, you'll act as the emissary of the application development process and help design the overall ecosystem. You'll architect, design, develop, and implement applications and solutions to meet the most critical and complex requirements. As a Solution Architect, you'll provide technical oversight to design, development, and testing activities. It will be up to you to ensure that applications are reliable, scalable, and secure.

Essential Functions

• Develop and implement technical best practices for data movement, data quality, data cleansing, and other ETL-related activities; Designs and implements solutions requiring integration of multiple platforms, operating systems and applications across the enterprise.; Ensures efficient design of systems; Maintains and improves current portfolio of solutions


• Lead and mentor other architects and analysts in the support of the above responsibilities; Develop ideas and solutions within different situations


• Recommend changes based on results to increase performance; Serves as a technical lead in the design and implementation of new enterprise solutions


• Develop and ensure adherence to locally defined standards for all developed components 3.3 Read Data Models to translate them into ETL or ELT loads into Data Warehouses and Data Marts 3.4 Help administer and maintain the ETL environment in a support role with DBAs


• Proficiency in requirements analysis, report building, or other data management related experience;Advanced knowledge of physical database design and data structures


• Expert knowledge of one or more database management systems Knowledge of interface engines and protocols.


• Knowledge of commonly used concepts, practices, and procedures as they relate to information systems design, engineering, administration and management.


• Provides thought leadership regarding applications of technology to business needs; Works directly with customers, both internal and external, to understand their needs and conveys those needs to other team members; Has a strong understanding of many aspects of the business; Works across teams to build consensus on direction and timing; Drives all aspects of system design including performance, scalability, security, etc.


• Coordinates cross team dependencies; Works with external vendors to ensure deliverables meet company needs and standards; Enforces industry and company best practices; Owns the development, maintenance, and enforcement of enterprise standards around development practices, processes, and tools; Works with Enterprise Architecture to ensure solutions are in alignment with current needs and future objectives; Builds out proofs of concepts in order to 'fail fast' on complex projects


• Work with cross-functional resources such as UX Designers, DBAs, Infrastructure, etc.;


• Serves as a technical subject matter expert; Develop data quality components and establish and/or conduct unit tests; Assists in building technical roadmaps; Develop dimensional data models to support reporting through BI platform


• Communicate with stakeholders across the organization to understand business requirements and ensure data architecture solutions are integrated within existing systems and workflows


• Keep abreast with new data management technologies and industry trends, recommend improvements to existing data architecture solutions to ensure solutions remain effective and efficient. Develop data quality components and establish and/or conduct validation testing


• Remote eligible.

The job summary and responsibilities listed above are designed to indicate the general nature of the work performed within this job. They are not designed to contain or be interpreted as a comprehensive inventory of all job responsibilities required of employees assigned to this job. Employees may be required to perform other duties as assigned.

Job Requirements

• Bachelors degree in Computer Science, Information Technology or related field or5 years of related job or industry experience in lieu of degree


• Eight to ten (8-10) years experience with ETL automation, data management, warehousing Reporting systems or interface design, development and maintenance


• Five (5) years experience in leading the above process within a team environment with multiple team members


• Experience with data management platforms (e.g. SSIS, SSAS, InfoSphere, Talend, Informatica, SAS) Experience with HL7, X12, XML, XSLT, and XSD


• Experience with Service Bus Architecture and transaction management systems such as Microsoft BizTalk Server, Microsoft Message Queue, Edifecs or similar