Business Intelligence Developer (W2 Only)

AYR Global IT Solutions Inc; Seattle (WA); On-site; Full time

Job summary

A national staffing firm is hiring a Business Intelligence Developer for a 3+ month contract in Seattle. The role involves creating data tables in VANS Redshift, migrating jobs to a new cluster, and developing EDX jobs for data extraction. Candidates should have 5+ years in data modeling and ETL, along with preferred skills in AWS, Big Data platforms, and proficiency in business intelligence tools. There's potential for extension and conversion to FTE.

Qualifications

• 5+ years of data modeling, ETL, and Data Warehousing experience, or 2 years related Amazon experience.
• 4+ years of experience in data modeling and transformation of large-scale data sources.
• Experience with AWS and Big Data platforms.

Responsibilities

• Create new data tables in VANS redshift cluster to meet PM requirements.
• Migrate data jobs to the new cluster.
• Implement new EDX jobs to extract partner teams and customer order history.

Skills

Data modeling

ETL

Data Warehousing

AWS

Big Data Platforms (Spark/Hive/Hadoop)

Redshift

Python

Business Intelligence tools (Tableau, MicroStrategy, etc)

Soft Skills (Fast-paced, Self-motivated)

Job description

Business Intelligence Developer (W2 Only)

• Contract

AYR Global IT Solutions is a national staffing firm focused on cloud, cyber security, web application services, ERP, and BI implementations by providing proven and experienced consultants to our clients. Our competitive, transparent pricing model and industry experience make us a top choice of Global System Integrators and enterprise customers with federal and commercial projects supported nationwide.

Title: Business Intelligence Developer
Duration: 3+ month contract
Location: Seattle, WA

Responsibilities

• Creation of new data tables in VANS redshift cluster to match PM requirements.
• Migration of data jobs to new cluster.
• New EDX jobs to pull relevant partner teams and customer order history data.
• 9 to 5 work day—40 hours. Overtime will be required on an as needed basis.
• Good possibility of extension and eventually conversion to FTE depending on performance.

Required Skills

• Data modeling, ETL, and Data Warehousing experience 5+ years; or 2 years related Amazon experience
• 4+ years of experience data modeling and transformation of large scale data sources

Preferred Skills

• Experience with AWS and Big Data Platforms such as Spark/Hive/Hadoop
• Experience with MPP databases such as Redshift or Netezza
• Experience with data processing using custom scripts to pull and load from APIs or Files.
• Experience with Python or similar programming/scripting language(s).
• Experience influencing software engineering best practices within your team
• Experience working with business intelligence tools such as Tableau, MicroStrategy, Oracle BI, Pentaho, etc

Soft Skills

• People who are very focused and have experience working on a fast pace. The team has a lot of day to day work and deliverables. Projects or reports that need to be completed within a couple of hours or day and delivered.
• Someone who has experience working in an environment with day to day deliverables, scrappy with their work, deliver fast 80% accuracy is good enough, not very detail oriented, this is not a position for people who are not able to handle ambiguity.
• Someone is not sticking to formality, not sticking to books, how does shopping really work, going extra mile.
• Great opportunity for extension and conversion to FTE.
• Self-motivated, independent and goal-oriented, a fast learner with good communication skills

If anyone might be interested, please share your resume at smalik(at)ayrglobal(dot)com or you can directly contact me at 630-444-7490