Data Analyst - ETL/SSIS/SQL/PowerBI

We are a fast growing and dynamic international company with a young and dedicated multicultural team. We have an agile mindset, but we work with rigor to satisfy our industry leading clients (including several Fortune 500 companies) and to build and maintain strong and long-lasting partnerships. The Data Analyst - ETL/SSIS/SQL/PowerBI at Pivot88 is responsible for ensuring successful design, development and completion of Data and Cockpit related projects at Customer’s satisfaction, ensuring Customer’s loyalty and durability.

Requirements

• Design database objects as necessary to meet ongoing business needs for reporting
• Maintain and support existing stored procedures, functions, views, etc.
• Support Provider data repository functionality and cleanup effort
• Support QC data integration; query existing data to produce properly formatted text files based on design specs provided
• Document new ETL processes
• Design, build, test, and execute ETL packages (using SSIS)
• Automate ETL jobs for recurring imports
• Create data file extractions and scripts (using T-SQL) to perform data related imports and data related tasks
• Work with data owners to understand legacy data and gather data requirements from the business. Be able to produce detailed data mapping documents
• Perform data analysis and recommend data optimization/performance opportunities
• Development and implementation of Power BI
• Other duties assigned as needed

Benefits

• Generous Paid Time Off
• 401k Matching
• Retirement Plan
• Visa Sponsorship
• Four Day Work Week
• Generous Parental Leave
• Tuition Reimbursement
• Relocation Assistance