This job has expired
Check similar jobs, what people also searched, or create a job alert for Data Architect jobs in Cleveland, OH
Jobs via Dice
Data Architect
Save Job
Summary
Must be able to work on a W2 without sponsorship, we aren't allowing C2C at this time.
Description
Primary Purpose
The Data Architect plays a crucial role in designing, developing, and maintaining the organization's business data architecture, ensuring data quality, availability, and security. This individual will collaborate with business stakeholders, developers, and other technical and business teams to understand data needs and translate them into robust and scalable data solutions.
The Data Architect role's primary focus will be the understanding, enhancement, and ongoing evolution of the business data warehouse in SQL Server. This will involve close collaboration with other IS and Analytics data professionals to integrate new data sources and ensure the continuous fulfillment of the organization's analytical, reporting and operational requirements.
Essential Duties & Responsibilities
Data Architecture & Development
Design, develop, and implement data warehouse and data mart solutions, including schema design, data loading, and query optimization.
Write and optimize complex SQL queries for data extraction, transformation, and analysis.
Design and implement data integration solutions, including ETL (Extract, Transform, Load) processes using appropriate tools and techniques
Architect data pipelines leveraging API integrations, file - based data feeds, ODBC connections etc.
Collaborate with business stakeholders, developers, and other technical teams to understand data needs and translate them into technical solutions
Other duties as assigned
Data Modeling & Governance
Develop and maintain a comprehensive enterprise data architecture framework that serves as a blueprint for managing organizational data assets.
Create and manage conceptual and logical data models to represent data entities, structures and relationships.
Develop and maintain physical data models optimized for the performance and characteristics of target systems, including relational databases (e.g., SQL Server), NoSQL databases, data warehouses, and data lakes.
Design and maintain data flow diagrams to visualize the movement and transformation of data across systems.
Develop, manage, and help maintain a central data dictionary to ensure consistent understanding and definition of data elements.
Establish and enforce data governance policies and procedures, including data quality rules, data security standards, and data access controls
Contribute to the development of the overall data strategy for the organization, aligning data architecture with business goals and objectives
Technology Advancement & Optimization
Remain current with the latest trends, technologies, and advancements in data architecture and data management, including developments in artificial intelligence (AI) and machine learning, and explore their potential application within the organization.
Conduct proof-of-concept and pilot projects to assess the feasibility and benefits of new technologies.
Work with other data professionals on monitoring system performance metrics and proactively identifying areas for optimization of data storage and retrieval processes
Technical Expertise & Knowledge Sharing
Communicate data architecture concepts and solutions effectively to both technical and non-technical audiences.
Provide guidance, mentorship, and knowledge sharing to other data professionals within the organization to promote a data-drive culture.
Create and help maintain comprehensive documentation for all aspects of data architecture, including data models, data integration processes, and architectural decisions.
Education & Experience
A four-year university or college degree is required, preferably in the field of Computer Science or Information Systems.
Minimum 5-10 years of experience in data architecture, data modeling, and data integration focused role
Robust understanding of data architecture principles, best practices, and patterns
Proficiency in data modeling tools and techniques
Extensive experience with various database technologies, including relational databases (SQL Server preferred) and data warehouses
Experience with ETL tools and techniques
Extensive experience (5+ years) with SQL (tsql preferred, GoogleSQL a plus) including DDL (stored procedures, functions etc.)
Experience with common programming languages including .Net (c#), python
Experience with data governance frameworks and tools is a plus
Experience with cloud-based data platforms (Azure preferred) is a plus
Experience with big data technologies (e.g. Databricks) is a plus
Experience with data visualization tools (Tableau preferred) is a plus
Experience leveraging AI models in daily tasks, including programming (e.g., ChatGPT, Gemini, GitHub Copilot).
Job Skills
Demonstrated project leadership, team building, collaborative, and project management skills
Ability to work independently and as part of a team
Excellent written, oral, and interpersonal communication skills
Proven analytical and problem-solving skills
Ability to conduct and direct research into issues and products as required
Ability to prioritize and execute tasks in a high-pressure environment and make sound decision in emergency situations
Ability to present ideas in a business and user-friendly language.
Organizational Requirements
Reads, speaks, comprehends, and communicates English effectively in all communications.
Represents the Cleveland Guardians in a positive fashion to all business partners and the general public.
Ability to develop and maintain successful working relationships with members of the Front Office.
Ability to act according to the organizational values and service excellence at all times.
Ability to work with diverse populations and have a demonstrated commitment to social justice.
Ability to walk, sit or stand for an entire shift.
Ability to work extended days and hours, including holidays and weekends.
Ability to move throughout all areas and levels of the Ballpark.
Ability to work in a diverse and changing environment.
Occasional physical activity such as lifting and carrying boxes up to 25 lbs.
Skills
Sql, etl, c-sharp, data architecture, azure, tableau, Google Cloud Platform, power bi
Top Skills Details
Sql,etl,c-sharp,data architecture,azure,tableau
Additional Skills & Qualifications
Intermediate Level
Pay And Benefits
The pay range for this position is $100000.00 - $130000.00/yr.
CLEVELAND GUARDIANS ORGANIZATION
Benefits Summary Full-time Associates
(Please refer to your Associate Handbook for additional benefits details including FMLA)
Health Insurance Plan - Medical, RX, Dental & Vision
(Formerly referred to as Option 2)
Medical Insurance - Medical Mutual of Ohio - Website: or 1-
$600 single/$1200 family annual deductible, while using Network physicians or $2,000 / $4,000 Non-Network physicians;
you may pay a $15 co-payment or up to 20% depending upon Network services; no claim forms required; premiums: Full
coverage/Single: $108.46 (tobacco user: $136.15); Full coverage/Two person: $124.62 (tobacco user: $152.31); Full
coverage/Family: $152.31 (tobacco user: $180.00). All premiums are paid (pre-tax) through bi-weekly payroll deductions
(26 pay period deductions). You will receive an all-inclusive insurance card in the mail. Coverage is active approximately
one week from enrollment completion. If medical insurance is waived, must provide proof of coverage through other
insurance carrier. Payback option if entire insurance package is waived. This Plan, formerly referred to as Option 2, meets
all the requirements of the Affordable Care Act.
Prescription plan - Express Scripts - Website: ;br>You pay 20% for prescriptions purchased at participating pharmacies listed in the Express Scripts Network, Non-Network
pharmacies and through Mail Order; through Mail Order, you can receive a 90-day supply (with written prescription).
Mandatory Mail Order for maintenance drugs. Coverage is active approximately one week from enrollment completion.
Prescription coverage meets all the requirements of the Affordable Care Act. Members may enroll in the SaveonSP
program, designed to offer a savings on certain specialty drugs.
Cost of Dental and Vision if purchased separately:
SDC Network: or 1-
$50 single/ $150 family annual deductible. Costs are the same whether in Network on Non-Network. Benefit Period
Maximum per member is $1,500; Lifetime maximum of $1,500 for orthodontia; no claim forms required; Premiums: Dental
Only/Single: $13.01; Two-person: $27.34; Family: $44.27. All premiums are paid (pre-tax) through bi-weekly payroll
deductions. (26 pay period deductions). Coverage is active approximately one week from enrollment completion.
Vision Insurance - EyeMed Services: or 1- (Customer Service)
See PPO booklet or website for participating doctor; 100% coverage for annual exam, plus encounter fee of $15; Up to
$100 covered for frames every 12 months; $15 copayment for lenses, restrictions apply; Coverage also available outside of
the Network with reduced reimbursement costs for lenses, frames, and contacts. Premiums: Vision Only/Single: $1.34;
Two-person: $2.83; Family: $4.60. All premiums are paid (pre-tax) through bi-weekly payroll deductions. (26 pay
period deductions). Coverage is active approximately one week from enrollment completion.
2
10.16.24 AJ
Life Insurance:
Company Paid Life Insurance, Long Term Disability & Accidental Death & Dismemberment
Life Insurance through Medical Mutual Life equals one times your annual salary up to $50,000; AD&D equals one times
your annual salary up to $50,000; Long Term Disability equals 60% of your monthly wage up to $5,000 monthly;
Premiums covered 100% by organization and your coverage begins after 90 days of employment. Life insurance does not
include commission or bonus, base pay only.
Supplemental Life and AD&D
Opportunity to purchase Supplemental Life Insurance and AD&D through Medical Mutual Consumers Life during our Open
Enrollment period; Evidence of Insurability must be provided at that time; Premiums are automatically taken through
monthly payroll deductions. Optional Life insurance does not include commission or bonus, base pay only.
Retirement Planning:
401K Plan
We are pleased to provide Cleveland Guardians associates and Minor League Players with assistance in saving for your
retirement. All new full-time employees will be automatically enrolled at 3% in our 401K Plan through Charles
Schwab. The plan offers a diverse menu of investment options including target date retirement funds. Employees can
invest up to 100% of their salary (not to exceed the annual IRS cap). For those not interested in participating, a
waiver form MUST be completed. The Plan allows for monthly enrollment following your hire date. You can change
your deferral amount at any time after enrollment by contacting Charles Schwab directly 1- or
workplace.schwab.com.
After meeting the eligibility requirements; At least 21 years of age, worked at least 1,000 hours in a 12-month
eligibility period, you are eligible for the following:
Automatic Club Contribution - The Guardians will provide a 6% employer contribution that is 100% immediately
vested. Club Matching Contribution - The Guardians will match 50% up to 6% of your elective deferrals into
Workplace Type
This is a hybrid position in Cleveland,OH.
Application Deadline
This position is anticipated to close on May 13, 2025.
About TEKsystems And TEKsystems Global Services
We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.
Description
Primary Purpose
The Data Architect plays a crucial role in designing, developing, and maintaining the organization's business data architecture, ensuring data quality, availability, and security. This individual will collaborate with business stakeholders, developers, and other technical and business teams to understand data needs and translate them into robust and scalable data solutions.
The Data Architect role's primary focus will be the understanding, enhancement, and ongoing evolution of the business data warehouse in SQL Server. This will involve close collaboration with other IS and Analytics data professionals to integrate new data sources and ensure the continuous fulfillment of the organization's analytical, reporting and operational requirements.
Essential Duties & Responsibilities
Data Architecture & Development
Design, develop, and implement data warehouse and data mart solutions, including schema design, data loading, and query optimization.
Write and optimize complex SQL queries for data extraction, transformation, and analysis.
Design and implement data integration solutions, including ETL (Extract, Transform, Load) processes using appropriate tools and techniques
Architect data pipelines leveraging API integrations, file - based data feeds, ODBC connections etc.
Collaborate with business stakeholders, developers, and other technical teams to understand data needs and translate them into technical solutions
Other duties as assigned
Data Modeling & Governance
Develop and maintain a comprehensive enterprise data architecture framework that serves as a blueprint for managing organizational data assets.
Create and manage conceptual and logical data models to represent data entities, structures and relationships.
Develop and maintain physical data models optimized for the performance and characteristics of target systems, including relational databases (e.g., SQL Server), NoSQL databases, data warehouses, and data lakes.
Design and maintain data flow diagrams to visualize the movement and transformation of data across systems.
Develop, manage, and help maintain a central data dictionary to ensure consistent understanding and definition of data elements.
Establish and enforce data governance policies and procedures, including data quality rules, data security standards, and data access controls
Contribute to the development of the overall data strategy for the organization, aligning data architecture with business goals and objectives
Technology Advancement & Optimization
Remain current with the latest trends, technologies, and advancements in data architecture and data management, including developments in artificial intelligence (AI) and machine learning, and explore their potential application within the organization.
Conduct proof-of-concept and pilot projects to assess the feasibility and benefits of new technologies.
Work with other data professionals on monitoring system performance metrics and proactively identifying areas for optimization of data storage and retrieval processes
Technical Expertise & Knowledge Sharing
Communicate data architecture concepts and solutions effectively to both technical and non-technical audiences.
Provide guidance, mentorship, and knowledge sharing to other data professionals within the organization to promote a data-drive culture.
Create and help maintain comprehensive documentation for all aspects of data architecture, including data models, data integration processes, and architectural decisions.
Education & Experience
A four-year university or college degree is required, preferably in the field of Computer Science or Information Systems.
Minimum 5-10 years of experience in data architecture, data modeling, and data integration focused role
Robust understanding of data architecture principles, best practices, and patterns
Proficiency in data modeling tools and techniques
Extensive experience with various database technologies, including relational databases (SQL Server preferred) and data warehouses
Experience with ETL tools and techniques
Extensive experience (5+ years) with SQL (tsql preferred, GoogleSQL a plus) including DDL (stored procedures, functions etc.)
Experience with common programming languages including .Net (c#), python
Experience with data governance frameworks and tools is a plus
Experience with cloud-based data platforms (Azure preferred) is a plus
Experience with big data technologies (e.g. Databricks) is a plus
Experience with data visualization tools (Tableau preferred) is a plus
Experience leveraging AI models in daily tasks, including programming (e.g., ChatGPT, Gemini, GitHub Copilot).
Job Skills
Demonstrated project leadership, team building, collaborative, and project management skills
Ability to work independently and as part of a team
Excellent written, oral, and interpersonal communication skills
Proven analytical and problem-solving skills
Ability to conduct and direct research into issues and products as required
Ability to prioritize and execute tasks in a high-pressure environment and make sound decision in emergency situations
Ability to present ideas in a business and user-friendly language.
Organizational Requirements
Reads, speaks, comprehends, and communicates English effectively in all communications.
Represents the Cleveland Guardians in a positive fashion to all business partners and the general public.
Ability to develop and maintain successful working relationships with members of the Front Office.
Ability to act according to the organizational values and service excellence at all times.
Ability to work with diverse populations and have a demonstrated commitment to social justice.
Ability to walk, sit or stand for an entire shift.
Ability to work extended days and hours, including holidays and weekends.
Ability to move throughout all areas and levels of the Ballpark.
Ability to work in a diverse and changing environment.
Occasional physical activity such as lifting and carrying boxes up to 25 lbs.
Skills
Sql, etl, c-sharp, data architecture, azure, tableau, Google Cloud Platform, power bi
Top Skills Details
Sql,etl,c-sharp,data architecture,azure,tableau
Additional Skills & Qualifications
- They are currently using c# and SQL to do their ETL. They have a program written in c# that does all the pulling up of flat files called APIs, where the data is and they they usually jam that in some sort of staging tables in the data base and do the rest using stored procedures of SQL.
Intermediate Level
Pay And Benefits
The pay range for this position is $100000.00 - $130000.00/yr.
CLEVELAND GUARDIANS ORGANIZATION
Benefits Summary Full-time Associates
(Please refer to your Associate Handbook for additional benefits details including FMLA)
Health Insurance Plan - Medical, RX, Dental & Vision
(Formerly referred to as Option 2)
Medical Insurance - Medical Mutual of Ohio - Website: or 1-
$600 single/$1200 family annual deductible, while using Network physicians or $2,000 / $4,000 Non-Network physicians;
you may pay a $15 co-payment or up to 20% depending upon Network services; no claim forms required; premiums: Full
coverage/Single: $108.46 (tobacco user: $136.15); Full coverage/Two person: $124.62 (tobacco user: $152.31); Full
coverage/Family: $152.31 (tobacco user: $180.00). All premiums are paid (pre-tax) through bi-weekly payroll deductions
(26 pay period deductions). You will receive an all-inclusive insurance card in the mail. Coverage is active approximately
one week from enrollment completion. If medical insurance is waived, must provide proof of coverage through other
insurance carrier. Payback option if entire insurance package is waived. This Plan, formerly referred to as Option 2, meets
all the requirements of the Affordable Care Act.
Prescription plan - Express Scripts - Website: ;br>You pay 20% for prescriptions purchased at participating pharmacies listed in the Express Scripts Network, Non-Network
pharmacies and through Mail Order; through Mail Order, you can receive a 90-day supply (with written prescription).
Mandatory Mail Order for maintenance drugs. Coverage is active approximately one week from enrollment completion.
Prescription coverage meets all the requirements of the Affordable Care Act. Members may enroll in the SaveonSP
program, designed to offer a savings on certain specialty drugs.
Cost of Dental and Vision if purchased separately:
SDC Network: or 1-
$50 single/ $150 family annual deductible. Costs are the same whether in Network on Non-Network. Benefit Period
Maximum per member is $1,500; Lifetime maximum of $1,500 for orthodontia; no claim forms required; Premiums: Dental
Only/Single: $13.01; Two-person: $27.34; Family: $44.27. All premiums are paid (pre-tax) through bi-weekly payroll
deductions. (26 pay period deductions). Coverage is active approximately one week from enrollment completion.
Vision Insurance - EyeMed Services: or 1- (Customer Service)
See PPO booklet or website for participating doctor; 100% coverage for annual exam, plus encounter fee of $15; Up to
$100 covered for frames every 12 months; $15 copayment for lenses, restrictions apply; Coverage also available outside of
the Network with reduced reimbursement costs for lenses, frames, and contacts. Premiums: Vision Only/Single: $1.34;
Two-person: $2.83; Family: $4.60. All premiums are paid (pre-tax) through bi-weekly payroll deductions. (26 pay
period deductions). Coverage is active approximately one week from enrollment completion.
2
10.16.24 AJ
Life Insurance:
Company Paid Life Insurance, Long Term Disability & Accidental Death & Dismemberment
Life Insurance through Medical Mutual Life equals one times your annual salary up to $50,000; AD&D equals one times
your annual salary up to $50,000; Long Term Disability equals 60% of your monthly wage up to $5,000 monthly;
Premiums covered 100% by organization and your coverage begins after 90 days of employment. Life insurance does not
include commission or bonus, base pay only.
Supplemental Life and AD&D
Opportunity to purchase Supplemental Life Insurance and AD&D through Medical Mutual Consumers Life during our Open
Enrollment period; Evidence of Insurability must be provided at that time; Premiums are automatically taken through
monthly payroll deductions. Optional Life insurance does not include commission or bonus, base pay only.
Retirement Planning:
401K Plan
We are pleased to provide Cleveland Guardians associates and Minor League Players with assistance in saving for your
retirement. All new full-time employees will be automatically enrolled at 3% in our 401K Plan through Charles
Schwab. The plan offers a diverse menu of investment options including target date retirement funds. Employees can
invest up to 100% of their salary (not to exceed the annual IRS cap). For those not interested in participating, a
waiver form MUST be completed. The Plan allows for monthly enrollment following your hire date. You can change
your deferral amount at any time after enrollment by contacting Charles Schwab directly 1- or
workplace.schwab.com.
After meeting the eligibility requirements; At least 21 years of age, worked at least 1,000 hours in a 12-month
eligibility period, you are eligible for the following:
Automatic Club Contribution - The Guardians will provide a 6% employer contribution that is 100% immediately
vested. Club Matching Contribution - The Guardians will match 50% up to 6% of your elective deferrals into
Workplace Type
This is a hybrid position in Cleveland,OH.
Application Deadline
This position is anticipated to close on May 13, 2025.
About TEKsystems And TEKsystems Global Services
We're a leading provider of business and technology services. We accelerate business transformation for our customers. Our expertise in strategy, design, execution and operations unlocks business value through a range of solutions. We're a team of 80,000 strong, working with over 6,000 customers, including 80% of the Fortune 500 across North America, Europe and Asia, who partner with us for our scale, full-stack capabilities and speed. We're strategic thinkers, hands-on collaborators, helping customers capitalize on change and master the momentum of technology. We're building tomorrow by delivering business outcomes and making positive impacts in our global communities. TEKsystems and TEKsystems Global Services are Allegis Group companies. Learn more at TEKsystems.com.
The company is an equal opportunity employer and will consider all applications without regard to race, sex, age, color, religion, national origin, veteran status, disability, sexual orientation, gender identity, genetic information or any characteristic protected by law.