Data Modeler at xScion Solutions

Posted on: 06/15/2022

Location: United States (REMOTE)

Original Source

Tags: spark sql salesforce hadoop

As an employee, you Turn Change Into Value™ – for our clients, for our company, for your professional growth, for the consumers. We hire the best and brightest, who are driven to create lasting value. At xScion, you aren’t just another team member, you’re **impactful**. You’re **empowered**. You’re **driven.** You’re an **xScioneer.** **As a Data Modeler, You Will:** * Utilize best practices for efficiency, accuracy and scalability - assist in driving strategy to design and implement the architecture that will serve as the foundation for a new BPMS (Business Process Management System) and re-engineered business processes * Work with product owners / business users to understand internal business processes and translate user stories and/or requirements for implementing, testing and maintaining data models * Manage both structured and unstructured data sets and utilize modeling tools such as ERWin or equivalent to create data models * Write and execute advanced SQL scripts (Join, Union, Create, Replace, Drop, Truncate, etc.) including query tuning * Prepare independent conclusions and offer alternative solutions to matters that may arise * Maintain open and honest lines of communication, provide project status updates and help resolve any data discrepancies * Demonstrate the ability to work collaboratively within a team environment **To Be Successful, You Need:** * 8-10 years hands-on work experience in Data Modeling (conceptual, logical, physical, and dimensional) using tools such as ERwin or equivalent within a Data Warehouse environment * Must be versed in different approaches to data architecture and applications including traditional and modern Data warehousing concepts and Data Lakes * Work experience with Normalized / Denormalized / Star / Snowflake / Kimball design concepts * Deep knowledge of MS SQL Server and data analysis * Experience in the nonprofit sector or pharma is a plus * STEM major is a plus * Refined communication skills (non-verbal, verbal and written) * Robust problem solving and independent, critical thinking skills with a strong aptitude for pattern recognition * Must be an organized, self-starter with a high change management capacity * Proven success of collaborating with associates spread amongst multiple locations or departments * Ability to proactively identify opportunities to enhance efficiencies and accuracy in order to exceed our client experience and expectations * Desire to work in a dynamic environment having a continuous improvement and development mindset * Preferred skillsets in working with various systems including: Hadoop, HQL (Hive), Spark, Talend, Informatica, Alteryx, Salesforce, BI Reporting (Tableau) * BS/MS Computer Science or STEM **Why xScion?** * **We have an amazing culture** – We were named a *Best Places to Work in Virginia* 5 years in a row (2020, 2019, 2018, 2017 & 2016). * **We are poised for rapid growth** – We are on the cutting edge of digital transformation in Financial Services, Healthcare, Nonprofit and Public Sector and continuously welcome new clients to the xScion family. * **We believe in your continuous development** – We invest in our teams’ development, including our Innovation Lab and paying for certifications and trainings to improve their skills because we are committed to collectively being the best at what we do. * **We want you to make an impact in whatever you do** – Our people have the opportunity to be the big fish in a smaller pond. * **You’ll work with the best** – We hire great people. Period. * **And because we truly care about you and our clients** - We are run by real people for real people, creating flexibility, balance, respect and fun in the workplace. * **Great Benefits**: medical, dental, 401(k) match, flexible spending and more, but we also have unique perks such as 26 days off a year (including your birthday!), company events, games, and many other things that inspire balance and flexibility. **We’re Transforming Businesses:** At xScion, we Turn Change Into Value. We help clients start or accelerate their digital transformation initiatives by shifting their mindset and goals into smaller, actionable steps that create lasting value. We specialize in Agile, Product Management, Business Process Management, Cloud and Risk Management solutions for clients in Financial Services, Public Sector, Nonprofits and Healthcare. As a Woman-owned company, we are proud to be the most trusted solutions partner that business and technology leaders count on to deliver lasting, impactful value. **Want to Learn More about xScion?** Check us at out on []( or socially at LinkedIn, Twitter and Glassdoor. At xScion, we celebrate diversity in all forms. xScion is an Equal Opportunity Employer- Females/Minorities/Protected Veterans/Individuals with Disabilities.