Back to jobs

Business Intelligence Analyst

HireRising
Onsite / United StatesFull time
Apply

About the role

Data Engineer, Business Intelligence Analyst

Contract-to-Hire, Phoenix, Arizona

(NO C2C Please)

About the Role

Seeking a hands-on Data Engineer to design, build, and maintain scalable data pipelines and analytics-ready data models across SQL Server and AWS Redshift. This role will use a Medallion architecture (Bronze, Silver, and Gold) to transform raw data from sales, e-commerce, finance, and operations systems into trusted data for reporting and analytics.

You will work closely with BI analysts, business stakeholders, and IT's data platform team to deliver reliable, high-quality data that powers Tableau dashboards and supports business decision-making.

Key Responsibilities

  • Design, build, and maintain data pipelines using a Medallion architecture.
  • Develop and optimize T-SQL, Redshift SQL, stored procedures, views, and queries.
  • Integrate data from databases, SaaS applications, APIs, and flat files using ETL/ELT tools.
  • Design dimensional data models, star schemas, and slowly changing dimensions.
  • Implement data quality checks, reconciliation, monitoring, and alerting.
  • Support the migration of legacy SQL Server workloads to AWS data lake and Redshift environments.
  • Collaborate with BI analysts and IT teams to deliver reliable, analytics-ready datasets.
  • Follow security, access control, source control, deployment, and change management standards.
  • Maintain data dictionaries, pipeline documentation, data lineage, and governance practices.
  • Automate data processing and orchestration using Python, workflow tools, and CI/CD pipelines.

Required Qualifications

  • 4+ years of professional data engineering experience building production data pipelines.
  • Advanced SQL Server skills, including T-SQL, stored procedures, indexing, query plans, and performance tuning.
  • Hands-on experience with AWS Redshift, including schema design, distribution keys, sort keys, and query optimization.
  • Experience implementing Medallion architecture or an equivalent layered data architecture.
  • Experience with at least two ETL/ELT tools or approaches, such as Fivetran, AWS Glue, SSIS, Airbyte, Matillion, Informatica, or Python.
  • Working knowledge of AWS services, including S3, IAM, Glue, Lambda, and CloudWatch.
  • Strong dimensional modeling skills, including Kimball methodology, star schemas, and slowly changing dimensions.
  • Experience with Git-based source control and structured deployment processes.
  • Strong communication and problem-solving skills, with the ability to explain technical concepts to non-technical stakeholders.
  • Bachelor's degree in Computer Science, Information Systems, or a related field, or equivalent practical experience.

Preferred Qualifications

  • Experience with Fivetran connectors, schema changes, sync scheduling, and usage-cost management.
  • Python skills for data processing and automation using pandas, boto3, or PySpark.
  • Experience with orchestration tools such as Apache Airflow, AWS Step Functions, or Dagster.
  • Familiarity with Apache Iceberg, Parquet, Athena, or Redshift Spectrum.
  • Experience with infrastructure-as-code tools such as Terraform or CloudFormation and CI/CD pipelines.
  • Experience preparing and optimizing data sources for Tableau dashboards and reporting.
  • Knowledge of data governance, PII handling, and role-based access controls.
  • AWS certification, such as AWS Certified Data Engineer – Associate.

What Success Looks Like

  • Reliable, well-monitored data pipelines that deliver accurate and timely data.
  • High-performing SQL Server and Redshift workloads.
  • Consistent, trusted business metrics across reporting and analytics.
  • Improved automation, data quality, and documentation.
  • Seamless collaboration with BI analysts, IT, and business stakeholders.

Search the jobs. Check the details. Make your move.

Compare recent openings by location, work format, pay, and experience level in one place.

Explore jobs
Smiling man pointing at a “Job offer!” notification on his phone

Excellent

Rated 4.8 out of 5 based on 617 reviewsTrustpilot

by Megan F.

Job seeker

The filters made it easier to see roles that actually matched the way I want to work. I could compare options without opening dozens of tabs.

by Daniel B.

Developer

I liked being able to narrow the search to remote roles and check the requirements before taking the next step.

by Rachel A.

People operations

The listings are easy to scan. Work format, location, and experience level are right where I expect them.

by Marcus H.

Data analyst

Salary and location filters helped me focus on roles that were worth a closer look.

by Aisha K.

QA engineer

I found the job details clear and useful. It was simple to see which skills mattered for each role.

by Olivia G.

Support specialist

The search felt straightforward, and I could quickly switch between different kinds of jobs.

by Kevin T.

Account manager

It is easy to revisit roles that fit my experience. I would like to see even more openings in my area.

by Sophia R.

Product designer

I could check work format and salary before reading the full description. That made my search feel much clearer.

by Hannah S.

Project coordinator

The job pages put the important details together, so I knew what to expect before deciding to continue.

by Victor A.

DevOps engineer

The remote filter is useful and the listings are quick to scan. A few more country options would make it even better.

by Brandon L.

Job seeker

After a break from work, a simple search and clear filters helped me start looking again without feeling overwhelmed.

by Jessica M.

Marketing coordinator

The search is straightforward. I can move from a short result to the full role description in one click.

by Christopher H.

Operations manager

I like seeing salary, location, and experience level next to each role. It saves time when comparing openings.

by Ethan M.

Sales representative

The layout is clean and the job cards are easy to read. I am looking forward to a larger selection of listings.

by David R.

Support specialist

I found the different work formats easy to browse and could quickly open roles that matched my schedule.

Frequently asked questions

Answers about finding your next role

What can I search for?

Search by job title or keyword, then browse remote, hybrid, and onsite openings in one list.

Where can I find remote jobs?

Browse remote openings on Remote Amigo. Search by job title or keyword, then choose Remote in the work format filter. Check each listing for location or country requirements.

How do I narrow the results?

Choose a country, work format, minimum annual salary, and experience level. You can change or clear the filters at any time.

What will I see on a job page?

Each listing shows the role, company, location, work format, salary when available, skills when provided, and a job description.

Do I need an account to browse jobs?

No. You can search and read the available listings without signing in.

Does this site submit job applications for me?

No. You can search and review listings here. The Apply button starts the job preference quiz; it does not submit an application to an employer.

Where do the jobs come from?

Listings are imported from public job feeds and job sites. Job details may change at the original source, so confirm the latest information before applying.

How recent are the listings?

Search results include listings with a publication date in the last 30 days. If a source provides no publication date, the import date is used; the actual posting may be older.

Can I search for remote jobs only?

Yes. Select Remote in the job type filter to show remote listings. You can switch to Hybrid or Onsite whenever you want.

What is the difference between remote, hybrid, and onsite?

Remote roles are intended to be done away from an office. Hybrid roles combine remote and office work. Onsite roles are based at a workplace. Always read the listing for its exact location requirements.

Can I filter jobs by country?

Yes. Choose a country in the search form to narrow the listings. A remote role may still have country restrictions, so check its description before applying.

Why do some jobs have no salary listed?

Some listings do not include pay information. We show a salary when it is available and leave it out when it is not provided.

Is the salary filter a monthly or annual amount?

The minimum salary field uses US dollars per year. It filters listings that have comparable salary information.

Can I change or clear my search filters?

Yes. Change the keyword, country, job type, salary, or level in the search form. You can clear individual fields and run a broader search again.