Senior Technical Analyst - Snowflake at Ball Aerospace

| Greater Denver Area
Sorry, this job was removed at 11:44 a.m. (MST) on Thursday, June 10, 2021
Find out who's hiring in Colorado.
See all Data + Analytics jobs in Colorado

Ball Corporation manufactures aluminum packaging for beverage, personal care and household products, and provides aerospace and other technologies for commercial and government customers. We have been in business for over 140 years and is leading the charge in creating solutions that keep our planet healthy. Ball Corp has been nationally recognized as a leading company in the creation of sustainable products (Fast Company World Changing Ideas award) as well as one of America's Best Employers for Diversity (Forbes Magazine.) Join our team of over 18,000 people worldwide in our quest to make the world a cleaner and healthier place. BE BIGGER THAN YOURSELF. BE UNSTOPPABLE. BE AN INSPIRATION. JOIN US IN MAKING THE WORLD A BETTER PLACE.



Primary Purpose of the Position:

This Senior Technical Analyst role, resides in ITS Global Application Operations function, which is responsible for Ball business applications globally. This role has responsibility for projects, business as usual and operational support. Business Process acumen and the ability to translate business requirements into ITS specifications , solution design and configuration in Snowflake product is key. Performs as the Technical Analyst of the project, responsible for leading, managing, and coordinating the initiatives responsible for the technical delivery of business systems and associated enhancements. Provides planning, estimates, application development, documentation, and support leadership using technology best practices. Participates as a key individual contributor in the design and development of complex applications and is the expert in the technology selected. Writes detailed specifications, derives estimates, and assigns component development tasks to the team. Implements solutions in alignment with the enterprise architecture blueprint as well as the solutions architecture and ensures that application designs adhere to standards and policies. Ensures that all information technology investments are clearly aligned with the priorities of the business. Performs hands-on development, mentors team members, and is accountable for technical deliverables. Accountable for technical specifications, team leadership, and delivery of complex, technical solutions to business needs


 

Essential Responsible Areas:

  • This is an operational and delivery position requiring an understanding of the overall Ball Business and Business Process .
  • Ability to translate Business demand requirements into ITS specifications, solution design, and complete configuration for implementation.
  • The Technical Analyst role is responsible for adherence to global strategic platform guidelines.
  • Provide planning, estimates, application development, documentation, and support leadership using technology best practices.
  • This role has an obligation to fully understand the Demand and Change Management Processes, associated SLA’s and ITS Standard operating procedures.
  • To produce complete and meaningful High Level Estimates (HLE’s) based on demand requests .
  • Participates as a key contributor in the design and development of complex applications and projects and is the expert in the technology selected.
  • Accountable to drive and ensure deliverables are complete based on defined timelines .
  • Responsible for detailed specifications, derives estimates, and assigns component development tasks to the onshore/offshore development teams.
  • Responsible for knowledge transfer to ITS operations.
  • Responsible for participating on operational readiness review , Disaster Recovery & Business continuity
  • To ensure ongoing support of deployed solutions is handled in the correct manner from both a Business and Ball ITS perspective, therefore minimizing Business impact
  • To effectively work in a Global Organization .
  • Build proactive and collaborative relationships with all teams internal or external
  • Be focused on the Ball Core Values
  • Participate in continuous improvement processes for operations and service delivery
  • Adhere to key KPI metrics such as SLA’s and OLA’s
  • Responsible for complying with software development life cycle (SDLC) policies to ensure delivery of quality solutions
  •  Performs as the Technical Analyst for the project. Provides leadership in the implementation and execution of technology solutions to complex business problems.
  • Works closely with program managers, developers, and other functional groups to understand the program schedules and provide work break down estimates.
  • Solves complex problems by taking a broad perspective to identify innovative technical solutions.
  •  Works with business analysts and solutions architect to determine technical feasibility.
  • Generates technical specifications for the projects
  • Oversees all test efforts to ensure quality of the product.
  • Participates as a key contributor in the design and hands-on development of complex applications.
  • Leads the effort to make sure the proper level of documentation is created and reviewed according to the software development process guidelines.
  • Performs requirements analysis
  • Conduct and participate in design review meetings
  • Supports project management tasks, such as estimating and planning dependencies/risks.
  • Implementation (e.g., installation, configuration, programming/customization, integration, data migration)
  • Conduct peer to peer Code reviews
  • Coordinate and perform unit testing. Reviews test plans/strategies to ensure software quality.
  • Participates in software release and post-release activities, including hypercare support.
  • Proven understanding and knowledge of interfaces or applications.
  • Ability to travel regionally & internationally

 

Position Requirement & Competencies:

  • Minimum 10+ experience in Data and Analytics
  • Bachelor’s degree required - Computer Science, MIS or equivalent
  • Experience in Kimball Data warehouse methodology is a must
  • 3+ Year experience with Snowflake SnowSQL and writing use defined functions
  • Hands-on experience with at least one Snowflake implementation
  • 3+ years experience developing ETL, ELT and Data Warehousing solutions
  • 3-5 years experience developing SQL scripts and stored procedures that processes data from databases
  • Expert skills with SQL, including using Snowflakes SQL extensions.
  • Experience designing and delivering complex, large-volume data warehouse applications
  • Minimum data modeling experience
  • Must be familiar with a project’s complete life cycle implementation of at least 1 to 2 projects.
  • Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design.
  • Strong analytical skills and ability to resolve problems are desired.
  • Excellent communications skills to include fluency in English - both written and verbal
  • Ability to work as part of a team or independently
  • ITIL experience – at least to foundation level desirable
  • MS Office, MS Outlook, MS Visio and MS Project
  • Experience in Global ITS operations environment is key.
  • Expertise in Snowflake – ELT using Snowflake SQL, implementing stored procedures and standard DWH+ETL concepts
  • Hands on experience in dashboarding and data modeling and reporting (ad hoc report generation) techniques.
  • Must be good at Data transformation, and set analysis.
  • Experienced in application designing, architecting, development and deployment using Qlik Sense. Must be efficient in front-end development and know visualization best practices.
  • Strong database designing and SQL skills. Experienced in RDMS such as Snowflake, MS SQL Server, Oracle etc.
  • Experience designing and delivering complex, large-volume data warehouse applications
  • Experience in reading and transforming complex XMLs, Flat file formats (For ex: csv, delimited,…) , DB look ups.
  • Must be familiar with a project’s complete life cycle implementation of at least 1 to 2 projects.
  • Strong experience in Data Quality, Source Systems Analysis, Business Rules Validation, Source Target Mapping Design, Performance Tuning and High Volume Data Loads.
  • Strong analytical skills and ability to resolve problems are desired.

Compensation & Benefits:

  • Hiring Salary Range: $ 77,500 - 115,500 (Salary to be determined by the applicant’s education, experience, knowledge, skills, and abilities, as well as internal equity and alignment with market data.)
  • Job Grade: 11
  • Other Compensation: This role will be eligible to participate in the annual incentive compensation plan.
  • Regular Full-Time Salaried and Hourly positions: Ball includes a comprehensive benefits structure, Go to our career site and click "Total Rewards" to learn more.

 

Ball Corporation has been made aware of reports involving fraudulent job offers. These often appear legitimate, but Ball does not make job offers until after a candidate has submitted a job application and has participated in a face-to-face interview (In person or via WebEx). All email correspondence from Ball Corporation ends in “@ball.com.” Please also be advised that Ball will never request payment or require candidates to deposit a check during the recruitment and onboarding processes. If you have questions about any open positions at Ball, please visit our careers website at https://jobs.ball.com/.


If you have applied to a position and have been asked for personal information through LinkedIn, please notify LinkedIn directly.


Equal Opportunity Employer

Minority, Female, Disabled, Lesbian, Gay, Bi-sexual, Transgender and Veterans

Read Full Job Description

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
    • C++Languages
    • JavaLanguages
    • JavascriptLanguages
    • PythonLanguages
    • RLanguages
    • SqlLanguages
    • SwiftLanguages
    • ParseLibraries
    • ReactLibraries
    • ReduxLibraries
    • DjangoFrameworks
    • FlaskFrameworks
    • Node.jsFrameworks
    • Ruby on RailsFrameworks
    • SparkFrameworks
    • TensorFlowFrameworks
    • AccessDatabases
    • DB2Databases
    • Microsoft SQL ServerDatabases
    • MongoDBDatabases
    • MySQLDatabases
    • OracleDatabases
    • RedisDatabases
    • SQLiteDatabases
    • IllustratorDesign
    • PhotoshopDesign
    • SolidWorksDesign
    • ConfluenceManagement
    • JIRAManagement
    • Microsoft ProjectManagement
    • WordpressCMS
    • SalesforceCRM

Location

10 Longs Peak Drive, Broomfield, CO 80021

What are Ball Aerospace Perks + Benefits

Culture
Volunteer in local community
Partners with Nonprofits
Friends outside of work
Intracompany committees
Team owned deliverables
Team based strategic planning
Group brainstorming sessions
Diversity
Dedicated Diversity/Inclusion Staff
Someone's primary function is managing the company’s diversity and inclusion initiatives
Diversity Employee Resource Groups
Health Insurance & Wellness Benefits
Dental Benefits
Vision Benefits
Health Insurance Benefits
Life Insurance
Retirement & Stock Options Benefits
401(K)
401(K) Matching
Employee Stock Purchase Plan
Match charitable contributions
Child Care & Parental Leave Benefits
Company sponsored family events
Vacation & Time Off Benefits
Generous PTO
Paid Holidays
Paid Sick Days
Professional Development Benefits
Job Training & Conferences
Tuition Reimbursement
Diversity Program
Lunch and learns
More Jobs at Ball Aerospace464 open jobs
All Jobs
Finance
Data + Analytics
Design + UX
Dev + Engineer
HR + Recruiting
Internships
Legal
Marketing
Operations
Product
Project Mgmt
Sales
Content
Data + Analytics
new
Denver
Project Mgmt
new
Denver
Operations
new
Denver
Internships
new
Boulder
Developer
new
Denver
Developer
new
Denver
Content
new
Denver
Developer
new
Denver
Developer
new
Denver
Developer
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Project Mgmt
new
Denver
Operations
new
Boulder
Developer
new
Denver
Internships
new
Denver
Internships
new
Denver
Data + Analytics
new
Denver
Operations
new
Denver
Developer
new
Boulder
Developer
new
Boulder
Internships
new
Denver
Developer
new
Boulder
Developer
new
Denver
Operations
new
Denver
Developer
new
Boulder
Internships
new
Boulder
Developer
new
Denver
Developer
new
Boulder
Finance
new
Denver
Project Mgmt
new
Denver
Developer
new
Denver
Developer
new
Denver
Content
new
Denver
Operations
new
Denver
Operations
new
Denver
HR + Recruiting
new
Denver
Developer
new
Boulder
Operations
new
Denver
Operations
new
Denver
Data + Analytics
new
Denver
Developer
new
Denver
Developer
new
Denver
Developer
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Operations
new
Denver
Operations
new
Denver
Data + Analytics
new
Denver
Developer
new
Denver
Developer
new
Denver
Data + Analytics
new
Boulder
Data + Analytics
new
Boulder
Data + Analytics
new
Denver
Operations
new
Denver
Developer
new
Denver
Developer
new
Boulder
Operations
new
Denver
Operations
new
Denver
Operations
new
Boulder
Operations
new
Boulder
Operations
new
Denver
Project Mgmt
new
Denver
Developer
new
Denver
Project Mgmt
new
Denver
Operations
new
Boulder
Project Mgmt
new
Denver
Developer
new
Boulder
Internships
new
Denver
Developer
new
Boulder
Developer
new
Boulder
Data + Analytics
new
Boulder
Developer
new
Denver
Marketing
new
Denver
Developer
new
Denver
Developer
new
Boulder
Developer
new
Boulder
Developer
new
Boulder
Operations
new
Denver
Developer
new
Boulder
Operations
new
Denver
Operations
new
Denver
Developer
new
Denver
Operations
new
Denver
Operations
new
Denver
Developer
new
Denver
Developer
new
Denver
Operations
new
Denver
Operations
new
Denver
Operations
new
Denver
Project Mgmt
new
Denver
Developer
new
Denver
Project Mgmt
new
Denver
Operations
new
Denver
Operations
new
Denver
Developer
new
Denver
Operations
new
Denver
Operations
new
Denver
Developer
new
Denver
Developer
new
Boulder
Developer
new
Boulder
Developer
new
Boulder
Developer
new
Boulder
Developer
new
Boulder
Developer
new
Boulder
Developer
new
Boulder
Operations
new
Boulder
Operations
new
Boulder
Data + Analytics
new
Boulder
Data + Analytics
new
Boulder
Sales
new
Boulder
Finance
new
Denver
Operations
new
Denver
Operations
new
Denver
Developer
new
Denver
Developer
new
Denver
Data + Analytics
new
Boulder
Developer
new
Denver
Design + UX
new
Denver
Developer
new
Boulder
Data + Analytics
new
Boulder
Operations
new
Denver
Operations
new
Denver
Operations
new
Boulder
Project Mgmt
new
Denver
Developer
new
Boulder
Developer
new
Boulder
Project Mgmt
new
Denver
Operations
new
Denver
Developer
new
Denver
Developer
new
Denver
Developer
new
Boulder
Operations
new
Denver
Developer
new
Denver
Data + Analytics
new
Denver
Operations
new
Denver
Operations
new
Boulder
Finance
new
Denver
Product
new
Denver
Design + UX
new
Denver
Developer
new
Denver
Operations
new
Denver
Developer
new
Denver
Operations
new
Boulder
Data + Analytics
new
Denver
Developer
new
Denver
Sales
new
Denver
Data + Analytics
new
Denver
Operations
new
Denver
Operations
new
Denver
Operations
new
Denver
Project Mgmt
new
Denver
Developer
new
Boulder
Developer
new
Boulder
Operations
new
Denver
Project Mgmt
new
Denver
Data + Analytics
new
Denver
HR + Recruiting
new
Denver
Developer
new
Denver
Data + Analytics
new
Boulder
Operations
new
Boulder
Developer
new
Boulder
Sales
new
Denver
Internships
new
Boulder
Developer
new
Denver
Operations
new
Boulder
Developer
new
Boulder
Internships
new
Denver
Operations
new
Denver
HR + Recruiting
new
Denver
Developer
new
Denver