Salary: $70,000- $90,000 per year (full-time/permanent)
****NOTE: For your application to be considered, all Preliminary Screening Questions at the end of this posting must be answered.****
Are you passionate about transforming raw data into meaningful insights that drive business decisions? Do you have a keen eye for detail and a knack for uncovering trends and patterns within complex datasets? If so, we invite you to bring your analytical expertise to our dynamic team. As a Data Analyst at On Side Restoration, you’ll play a pivotal role in extracting, analyzing, and interpreting data to provide actionable recommendations that fuel our strategic initiatives. Join us in the fast-paced world of data-driven decision-making, where your skills will make a direct impact on our company’s success. If you’re ready to turn numbers into narratives and help shape the future of our organization, we want to hear from you!
What you’ll do here:
- Design, develop, and deploy data pipelines using Azure Data Factory to ingest, transform, and load data from various sources into Microsoft Fabric.
- Architect data models and structures within Microsoft Fabric to support efficient querying and analytics.
- Optimize and tune data pipelines and queries for performance and scalability.
- Developing and maintaining data models and process optimization initiatives using Power BI as part of doing analytics.
- Monitor and troubleshoot data pipelines to ensure reliability and accuracy of data processing.
- Organizing large sets of data from various sources, cleaning, iterating, processing, and verifying the accuracy of data.
- Use Exploratory Data Analysis (EDA) and statistical modeling techniques to extract and summarize the overall features of data analysis.
- Identify, analyze and interpret patterns and trends (local and national) in complex data sets using statistical tools and methods for the purposes of diagnosis, inference and prediction.
- Designing and developing reports, dashboards, and other data visualization tools to present business intelligence insights to stakeholders.
- Providing recommendations based on data analysis to support business decision-making.
- Troubleshooting and resolving issues related to data quality, performance, and functionality.
- Collaborating with cross-functional teams to identify business needs and opportunities.
- Providing training and support to end-users of data lab solutions.
- Continuously monitoring and analyzing data to identify opportunities for improvement or optimization.
- Ensuring data privacy and security measures are in place.
What you need to be Successful
- Bachelor’s degree in computer science, Engineering, or a related field. Master’s degree preferred.
- Proven experience in designing and developing data pipelines using Azure Data Factory.
- Combination of advanced technical and sound communication (presentation) skills.
- A systematic and logical approach to problem-solving.
- Ability to work outside of regular business hours periodically, including the ability to travel up to 10% of the time.
What will help you be great!
- Hands-on experience with Microsoft Fabric /Azure Synapse Analytics (formerly Azure SQL Data Warehouse) for data warehousing and analytics.
- Experience with data modeling, ETL processes, and data warehousing concepts.
- Experience with a combination of the following: Power BI & Data Analysis Expressions (DAX), SQL, MS Office.
- Experience with R and Python programming (asset but not a requirement), and/or experience with another statistical analysis program will be considered.
- Technical proficiency regarding database design development, data models, techniques for data-mining, and segmentation
- Ability to work collaboratively in a team environment and communicate effectively with stakeholders.
What’s in it for you:
We are an established company in a growing industry, and we need awesome people! We WANT to start you off on a career path you’ll love, we WANT you to be fulfilled by your work and we WANT to provide you with opportunity to grow. We also love that we’re able to provide an employee assistance program, excellent health plan which includes extended medical (chiropractic, massage, acupuncture, vision, and more!) dental, long-term disability (LTD) and life insurance.
We provide on the job training with opportunity for development—promotions and national career movement are yours for the taking (well, with a few months under your belt). At On Side we work hard to embrace diversity and inclusion and encourage everyone to bring their authentic selves to work every day.
Get on our side!
Both major weather disasters and minor accidents involving water, fire, and more happen every day, and in our industry this is how we keep busy, restoring properties 24 hours per day, 7 days a week. Mother Nature usually doesn’t wait for an invitation, but we’re in the business of dealing with party crashers, and we’ve done it for over 40 years!
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Preliminary Screening Questions
- What kind of business data analysis have you done?
- Data engineering
- What have you done?
- How do you rate your skills between 1and 10 (10 being very strong).
- Data modelling
- What have you done?
- How do you rate your skills between 1and 10 (10 being very strong).
- What have you done in statistical modelling?
- What have you done?
- How do you rate your skills between 1and 10 (10 being very strong).
- How long have you been using Power BI?
- What have you done?
- How do you rate your skills between 1and 10 (10 being very strong).
