Sr. IT Data Warehouse Analyst Job at Tideworks Technology, Inc in Seattle

As a Senior IT Data Warehouse Analyst with the Carrix IT team at SSA Marine, you will be part of a cross-functional team involved in data and analytics who apply their passion for technology to solving real-world problems. You will use your creativity and analytical skills to affect change in a global industry, working within a cross-functional, agile-oriented team performing source system analyses, establishing business/data requirements and documentation, developing process flow models and other data-related deliverables, and ensuring client needs are considered throughout the data journey and lifecycle. Engaging regularly with both internal stakeholders and external clients, you will leverage active listening and problem-solving skills to improve processes, software, and technology solutions, ultimately delivering value by solving complex business problems for clients worldwide.

Responsibilities:

• Engaging with clients, internal stakeholders, and the technical community via workshops, meetings, interviews, etc., to capture technical requirements and specifications.
• Identify and document source systems, data structures, and data quality issues.
• Define data mapping and transformation rules to ensure data accuracy and relevance.
• Integrate data from various sources into the data warehouse, ensuring data quality and consistency.
• Develop data dictionaries and other metadata.
• Work closely with data engineers, analytic engineers, and data analysts to ensure data extraction and transformation align with business needs.
• Develop and execute data validation and quality assurance processes to ensure data integrity.
• Participate in the design and implementation of data governance policies and procedures.
• Serve as a primary contact point for questions related to how a product, solution, or technology supports or enables work activities in a business process.
• Engage with clients, internal stakeholders, and technical SMEs to define the business rules that products and solutions need to support.
• Leverage systems analysis models and diagrams, such as activity diagrams, entity-relationship diagrams, etc., to solve problems.
• Develop specifications, diagrams, data mappings, flowcharts, and other artifacts for engineering teams.
• Recommend changes to existing solutions, platforms, and products, identifying impacted interfaces, and working with technical teams to implement and test changes.
• Verify if software, products, and/or services meet the client and organizational needs and goals.
• Coach others and apply advanced and strategic use of concepts and practices to complete assignments of moderate to high complexity with minimal direction.
• Work as a willing and valued team member accountable for achieving OKRs that drive organizational and client success.
• Create and manage against OKRs.
• Provide end-user training on analytical tools and dashboards.
• Other duties as assigned.

Requirements:

• Bachelor's degree in a related field or equivalent work experience (MS/MBA or higher-level degree preferred).
• 4+ years' work experience in an analytical or software development capacity, or equivalent experience; including testing and validation.
• Proficiency in working with stakeholders in capturing business and data requirements; including metric/KPI development.
• Proficiency in SQL, ETL, and data analysis tools.
• Experience with data visualization tools (i.e., Power BI).
• Experience with agile software development methodologies preferred.
• Experience with business process re-engineering concepts and methods preferred.

Knowledge, Skills and Abilities:

• Deep knowledge of data mapping/journey analysis and documentation methods.
• Ability to translate business requirements into technical specifications.
• Proficiency in data analysis tools and languages (i.e., SQL, Python, etc.).
• Familiarity with data integration techniques and tools (e.g. dbt, Boomi, Informatica).
• Familiarity with cloud data warehousing platforms (e.g. Snowflake).
• Understanding of data modeling and database design.
• Experience with data visualization tools (PowerBI, Tableau).
• Understanding of data security practices and the ability to ensure data protection and compliance.
• Deep knowledge of agile software development methodologies and best practices.
• Deep knowledge of the Microsoft Office Suite (e.g., Excel, Word, PowerPoint, SharePoint).
• Proven ability to work in a dynamic, varied, and fast-paced environment.
• Proven ability to adapt quickly to new technologies and changing business requirements.
• Proven ability to leverage leading problem-solving skills to solve complex problems.
• Proven ability to apply leading communication skills to present technical information in a concise manner to various stakeholders, verbally and in writing.
• Proven ability to apply project management skills to prioritize and multitask.
• Ability to apply active listening and collaboration skills to effectively engage both technical and non-technical stakeholders to achieve target outcomes.
• Ability to quickly learn the objectives, structures, operations, and policies of a business area.
• Ability to influence others using leading analytical & storytelling skills.
• Ability to negotiate and resolve conflicts.
• Ability to be flexible, adaptable, pragmatic, and committed.
• Ability to train end-users on the use of analytic tools and dashboards.

Work Environment:

• Exposure to computer screens.
• The noise level in the work environment is usually moderate.
• Required hybrid work schedule, at least 3 days/week in office.
• Required job duties are normally performed in a climate-controlled office environment.

We are an Equal Opportunity Employer

Compensation:

$110,000 - $130,000 per year

Benefits:

• Eligible employees (and their families) may qualify for medical, dental, and vision insurance, as well as having basic life and accidental death insurance, short-term disability insurance, and long-term disability insurance.
• Employees will receive paid sick and vacation time, and company holidays if eligible.
• The company also offers up to twelve weeks of paid maternity leave, when applicable, 5 days of paid bereavement leave, and paid jury duty.
• Eligible employees can enroll in our company's 401k plan, as well as a retirement plan.
• Some employees may be eligible for discretionary and/or metric-based bonuses dependent on their position.
• The company also provides an Employee Assistance Program.

This is a Hybrid role and consists of a combination of WFH and in-person work.