Data Architect

Data Architect
Location: Studio City
Who is Affinity:
Affinity is a privately held national Solutions Consulting firm based out of Milwaukee. We serve as strategic advisors and thought leaders to our Fortune 500 clients. Our clients and employees value our approach as a company "big enough to do complex, high impact work, but small enough to truly care". We focus on hiring motivated, intelligent professionals who have a passion for their work and a desire to grow along with us. Visit our website to learn more about us and all the exciting things we are doing here at Affinity: www.affinityit.com.
What will you do in this role:
Are you a Data Architect/Analyst who can oversee the build and management of a global real-time reporting system? We are seeking a senior level systems analyst with strong abilities in data management and business intelligence and how to apply these to a global solution. The project is focused on the subject areas of accounts receivable (AR), financial planning and analysis (FP&A), contract and title data management. We are looking for someone that is comfortable doing data analysis and modeling, along with higher level architecture work.
Key leader and contributor to the design and development of a scalable and cost-effective cloud-based data platform based on data lake designs.
Collaborative with team members, product management, architects, data producers and data consumers throughout the company.
Develop data platform components in a cloud environment to ingest data and events from cloud (and on-premise) environments, as well as third parties.
Build automated data delivery pipelines and services to integrate data from the data lake to internal and external consuming applications and services.
Experience architecting and implementing production grade BI solutions, preferably using Power BI or similar tools.
Experience as a database, data warehouse, big data/analytics developer or administrator.
Experience in data modeling, data analysis, and relational database design.
Possess significant experience in software development and/or IT and implementation/consulting experience.
Strong verbal and written communications skills are a must, as well as the ability to work effectively across internal and external organizations and virtual teams.
Hard skills include data architecture, ETL, SQL, and Node JS. Soft skills include strong communication both verbal and written. Documentation includes data and process flows, data models, design and function specifications, and the ability to apply Lean principles to new process development. The ability to work in an Agile environment and manage reports through the sprint process is valuable.
Experience with cloud integrations using Azure services include Logic Apps, Functional Apps, Analysis Services, Data Factory, and Azure SQL DB
Azure general expertise in API management, ODBC, and Oracle
Fluency in the four pillars of data - acquisition, cleaning, modelling, and visualization
Knowledge of Snowflake is useful
Power BI, Azure, MS SQL and Oracle + FPNA experience (Financial Planning & Analysis)
Media/TV/Entertainment industry experience
What we offer:
Competitive base salary, possibly C2c with option to hire as FTE
Full benefits including full medical, dental, 401K, PTO and holiday, disability, life, etc
A culture of collaboration
Challenging work at the enterprise level
Contemporary and emerging technologies
The opportunity for high-impact work
Respected partners
Entrepreneurial spirit
Collaborative performance reviews and career planning
Personalized training and career development
Opportunities for advancement
Unfortunately, at this time we cannot offer H1b sponsorship or transfer
Apply here or contact our fulfillment team directly!
Fulfillment Leader
Direct: 310.316.3737

Don't Be Fooled

The fraudster will send a check to the victim who has accepted a job. The check can be for multiple reasons such as signing bonus, supplies, etc. The victim will be instructed to deposit the check and use the money for any of these reasons and then instructed to send the remaining funds to the fraudster. The check will bounce and the victim is left responsible.

More Jobs

Big Data Architect, Manager - Data Delivery
San Jose, CA Deloitte
Big Data Architect, Manager - Data Delivery
San Diego, CA Deloitte
Big Data Architect, Manager - Data Delivery
Sacramento, CA Deloitte
Cloud Data Architect
San Francisco, CA Maven Wave
Big Data Architect
San Mateo, CA Drawbridge