"Alerted.org

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

Experience Level

Intermediate Level

Pay and Benefits

The pay range for this position is $100000.00 - $130000.00/yr.

CLEVELAND GUARDIANS ORGANIZATIONBENEFITS 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: www.medmutual.com or 1-800-362-5200$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: Fullcoverage/Single: $108.46 (tobacco user: $136.15); Full coverage/Two person: $124.62 (tobacco user: $152.31); Fullcoverage/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 approximatelyone week from enrollment completion. If medical insurance is waived, must provide proof of coverage through otherinsurance carrier. Payback option if entire insurance package is waived. This Plan, formerly referred to as Option 2, meetsall the requirements of the Affordable Care Act.Prescription plan – Express Scripts – Website: www.express-scripts.com1-800-417-1961You pay 20% for prescriptions purchased at participating pharmacies listed in the Express Scripts Network, Non-Networkpharmacies 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 SaveonSPprogram, designed to offer a savings on certain specialty drugs.Cost of Dental and Vision if purchased separately:SDC Network: www.medmutual.com or 1-866-336-8251$50 single/ $150 family annual deductible. Costs are the same whether in Network on Non-Network. Benefit PeriodMaximum per member is $1,500; Lifetime maximum of $1,500 for orthodontia; no claim forms required; Premiums: DentalOnly/Single: $13.01; Two-person: $27.34; Family: $44.27. All premiums are paid (pre-tax) through bi-weekly payrolldeductions. (26 pay period deductions). Coverage is active approximately one week from enrollment completion.Vision Insurance – EyeMed Services: www.medmutual.com or 1-877-226-1115 (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 ofthe 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 payperiod deductions). Coverage is active approximately one week from enrollment completion.210.16.24 AJLife Insurance:Company Paid Life Insurance, Long Term Disability & Accidental Death & DismembermentLife Insurance through Medical Mutual Life equals one times your annual salary up to $50,000; AD&D equals one timesyour 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 notinclude commission or bonus, base pay only.Supplemental Life and AD&DOpportunity to purchase Supplemental Life Insurance and AD&D through Medical Mutual Consumers Life during our OpenEnrollment period; Evidence of Insurability must be provided at that time; Premiums are automatically taken throughmonthly payroll deductions. Optional Life insurance does not include commission or bonus, base pay only.Retirement Planning:401K PlanWe are pleased to provide Cleveland Guardians associates and Minor League Players with assistance in saving for yourretirement. All new full-time employees will be automatically enrolled at 3% in our 401K Plan through CharlesSchwab. The plan offers a diverse menu of investment options including target date retirement funds. Employees caninvest up to 100% of their salary (not to exceed the annual IRS cap). For those not interested in participating, awaiver form MUST be completed. The Plan allows for monthly enrollment following your hire date. You can changeyour deferral amount at any time after enrollment by contacting Charles Schwab directly 1-800-724-7526 orworkplace.schwab.com.After meeting the eligibility requirements; At least 21 years of age, worked at least 1,000 hours in a 12-montheligibility period, you are eligible for the following:Automatic Club Contribution - The Guardians will provide a 6% employer contribution that is 100% immediatelyvested. 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.