What are the responsibilities and job description for the Senior Data Analyst position at Pursuit Aerospace?
About Us
As a global manufacturer of complex aircraft engine components, Pursuit Aerospace is founded on a commitment to relentless, continuous, operational improvement and extraordinary customer service. We pride ourselves on competitive cost structure, exceptional on-time delivery, and industry-leading quality.
The Pursuit family of companies has cultivated long-term relationships with our customers around the world through respect, teamwork, technology, and trust. We are driven to develop industry leading process innovations and manufacturing techniques on behalf of our customers. Our exceptional quality is driven by a deep investment in and the daily practice of continually improving our people, processes, and products.
About The Opportunity
As a Senior Data Analyst, you will be responsible for all Microsoft SQL Database Servers and will be working closely with BI team to create reports in Qlik and data migration into Snowflake.
Location: Remote, limited travel
Responsibilities
The above job description is not intended to be an all-inclusive list of duties and standards of the position. Incumbents will follow any other instructions, and perform any other related duties, as assigned by their supervisor.
Benefits
Pursuit Aerospace also offers a variety of benefits, including health and disability insurance, 401(k) match, flexible spending accounts, EAP, paid time off, and company-paid holidays. The specific programs and options available to an employee may vary depending on date of hire, schedule type, and the applicability of collective bargaining agreements, among other things.
Equal Opportunity Employer
Pursuit Aerospace is an Equal Opportunity Employer. We adhere to all applicable federal, state, and local laws governing nondiscrimination in employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
As a global manufacturer of complex aircraft engine components, Pursuit Aerospace is founded on a commitment to relentless, continuous, operational improvement and extraordinary customer service. We pride ourselves on competitive cost structure, exceptional on-time delivery, and industry-leading quality.
The Pursuit family of companies has cultivated long-term relationships with our customers around the world through respect, teamwork, technology, and trust. We are driven to develop industry leading process innovations and manufacturing techniques on behalf of our customers. Our exceptional quality is driven by a deep investment in and the daily practice of continually improving our people, processes, and products.
About The Opportunity
As a Senior Data Analyst, you will be responsible for all Microsoft SQL Database Servers and will be working closely with BI team to create reports in Qlik and data migration into Snowflake.
Location: Remote, limited travel
Responsibilities
- Configuring Servers and Databases
- Monitoring the performance of hardware and software
- Extracting and/or loading data
- Collaborate with System Analysts to support requirement for various ERP and Custom Apps
- Work with ERP vendors or Microsoft to resolve any database related issues
- Responsible for Backup policy and execution
- Manage license compliance and support contracts for all Microsoft databases
- Creates and maintains technical documentation for data structure and data flow
- Responsible for security and cyber security compliance of all Microsoft SQL servers.
- Collaborate with Design, Analyzes and test solutions for Qlik reports before formal launch
- Monitor and maintain Snowflake Tenet
- Actively seeks ways to improve business processes and interactions
- Stays current with emerging trends and technologies as relates to MS SQL Server
- Performs other related duties as assigned
- Bachelor’s degree in computer science, Information Technology, or related field
- At least 5 years of combined experience administering Microsoft SQL server databases and data analytics
- Advanced knowledge of SQL database administration and Extract Transform Load (ETL) processes
- Must be authorized to work in the U.S. on a full-time basis without sponsorship now or in the future. The Company cannot offer employment to visa holders who require employer sponsorship in the future or cannot work now on a full-time basis.
- Must be able to perform work subject to ITAR/EAR regulations.
- Experience working with BI tools and data warehousing such as Qlik, Snowflake, and DBT
- Experience with APIs and Version Control Systems such as Gitlab
- Experience with both on-premises and government cloud hosted ERPs
- Experience with Database replication tools like Microsoft SQL Server and Fivetran
- Experience with Snowflake AI Agents
- Thorough knowledge of report writing tools including the ability to create and modify new or existing reports
- Advanced knowledge of Business Intelligence best practices
- Qlik Cloud report app design and management
- DBT model design and maintenance
- Snowflake Data Warehousing
- Foundational knowledge of ERP functional areas
- Experience with using database Monitoring tools such as Solarwind
- Proficient with Microsoft Office, including Excel, Access, and PowerPoint
- Project Management skills
- Self-motivating skills to plan and accomplish individual and team goals
- Resourcefulness and troubleshooting skills
- Strong analytical and problem-solving skills
- Excellent interpersonal, written, and verbal communication, and presentation skills
- Ability to work independently and in a team environment
- Must be able to have prolonged periods sitting at a desk and working on a computer.
- Must be able to frequently sit, stand and walk.
- Must be able to lift and carry up to 15 pounds.
- Personal protective equipment (e.g., safety glasses and safety shoes) is required on the shop floor
- Occasional weekend and evening work may be required to accommodate priorities, deadlines, and schedules.
The above job description is not intended to be an all-inclusive list of duties and standards of the position. Incumbents will follow any other instructions, and perform any other related duties, as assigned by their supervisor.
Benefits
Pursuit Aerospace also offers a variety of benefits, including health and disability insurance, 401(k) match, flexible spending accounts, EAP, paid time off, and company-paid holidays. The specific programs and options available to an employee may vary depending on date of hire, schedule type, and the applicability of collective bargaining agreements, among other things.
Equal Opportunity Employer
Pursuit Aerospace is an Equal Opportunity Employer. We adhere to all applicable federal, state, and local laws governing nondiscrimination in employment. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
Salary : $107,000 - $129,000