Job Details

Ampcus Inc. is a certified global provider of a broad range of Technology and Business consulting services. We are in search of a highly motivated candidate to join our talented Team. Job Title: Agile1 Operations Data Analyst Career. Location: Oakland, CA. Position Summary:

• The Senior Data Analyst reports to the manager of Smart Meter Programs. This individual extracts data develops insights into analysis, initiatives and leadership support, and responds to ad hoc data requests.
• This role also maintains operational tools and databases to ensure that they are kept up to date using data from various Client systems. In this role, you will work with a diverse group of professionals including accounting, program management, resource planning, field operations, and IT - to deliver business solutions, automate workflows, and drive project success across multiple domains.

Job Responsibilities:

• Manage, monitor, and optimize ETL processes, primarily using SQL Server Integration Services (SSIS).
• Create complex automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing.
• Anticipate client concerns and questions, and provide proactive, timely and professional client-focused communications.
• Provide timely and professional responses to client inquiries or escalate as appropriate.
• Analysis of current processes and recommendations for process improvements.
• Maintain and enhance existing Power BI reports and dashboards for various business units.
• Review, update, and organize data solution documents for knowledge sharing and compliance.
• Collaborate with stakeholders to understand requirements, translate them into technical solutions, and communicate effectively.
• Assist in database administration, performance tuning, and troubleshooting complex SQL queries.
• Support data integrity, data quality, and data governance initiatives.

Top Things Looking For:

• Hands-on experience with SQL Server such as creating SSIS packages.
• Having the "Debugger" Mindset - able to do root case analysis.
• Cross-functional "translation" skills - The ability to explain a technical failure to a non-technical stakeholder.

Top Skill Sets Required in a Candidate:

• SQL, SSIS packages, data cleaning, PowerBI.
• Desire: PowerAutomate, Power App, Python.

Required Qualifications: Minimum:

• BA/BS Degree in Computer Science/Information Systems, Business, Engineering or other related field or equivalent work experience.
• At least 3 years' hands-on experience with relational databases (SQL Server preferred).
• Advanced proficiency in T-SQL, including complex queries.

Ampcus is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, protected veterans or individuals with disabilities.