What are the responsibilities and job description for the BI/Data Analyst position at Pyramid Consulting, Inc.?
Job Description
Immediate need for a talented BI/Data Analyst. This is a 06 Months contract opportunity with long-term potential and is located in Atlanta,GA(Remote). Please review the job description below and contact me ASAP if you are interested.
Job ID: 23-23121
Pay Range: $40-$45/hour. Employee benefits include, but are not limited to, health insurance (medical, dental, vision), 401(k) plan, and paid sick leave (depending on work location).
Key Responsibilities:
- Develops, builds, designs, and deploys business solutions, while maintaining advanced reporting, analytics, dashboards, and other BI solutions
- Develops and executes database queries and performs and documents data analysis, data validation, data mapping, design, produce data samples, prototypes and produce ad-hoc reports.
- Implements and optimizes data solutions in enterprise data warehouses and big data repositories.
- Ensures data quality and implements tools and frameworks for automating the identification of data quality issues.
- Develop re-useable processes that can be leveraged and standardized for multiple instances
- Works with internal and external data providers on data validation providing feedback and making customized changes to data feeds and data mappings.
- Recommends improvements to processes, technology, and interfaces that improve the effectiveness of the team and reduce technical debt.
- Ensure performance by monitoring existing workflows to ensure they are working correctly and that they reconcile with the source.
- Design and develop ETL workflows and datasets to be used in extracts by our BI reporting tool Tableau.
- Will write complex SQL queries with multiple joins to automate/manipulate these reporting extracts
- Works in partnership with marketing stakeholders concerning the accuracy of data and efficiency of processes
- Working experience with data modelling, data access, schemas, and data storage techniques within Snowflake
- Working experience with batch and real-time data processing frameworks
- Working experience working with relational databases such as SQL
- Working experience with business intelligence tools and platforms
- Working experience with data quality tools
- Working experience with Snowflake
- Working experience with Google Analytics
- Working Experience with Tableau Server
- Working experience with SQL Server Integration Services
- Top 5 Must Haves: Experience with Snowflake
- Experience with Tableau Server.
- Experience with web data & digital marketing data.
- Strong attention to detail to ensure data accuracy and reliability.
- Ability to produce clear, concise, and comprehensive documentation.
- Working experience with Snowflake
- Working experience with Google Analytics
- Working Experience with Tableau Server
- Working experience with SQL Server Integration Services
Our client is a leading Automotive organization and we are currently interviewing to fill this and other similar contract positions. If you are interested in this position, please apply today for immediate consideration.
Pyramid Consulting, Inc. provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.
Salary : $40 - $45