Data Warehouse Architect - SQL Server
Philadelphia, PA/ Las Vegas, NV
Infrastructure – Database Administration /
Full Time /
The FreedomPay Commerce Platform is the technology of choice for many of the largest companies across the globe in retail, hospitality, lodging, gaming, sports and entertainment, foodservice, education, healthcare and financial services. FreedomPay’s technology has been purposely built to deliver rock solid performance in the highly complex environment of global commerce. The company maintains a world-class security environment and was first to earn the coveted validation by the PCI Security Standards Council against Point-to-Point Encryption with EMV standard in North America. FreedomPay’s robust solutions across payments, security, identity and data analytics are available in-store, online and on-mobile and are supported by rapid API adoption. The award winning FreedomPay Commerce Platform operates on a single, unified technology stack across multiple continents allowing enterprises to deliver a consistent, repeatable experience on a global scale. FreedomPay is a fast paced, high growth company with a great culture with competitive benefits and compensation with a business casual atmosphere.
Position Requirements
- 8 or more years administering SQL Server on standalone or clustered servers with tasks including database backups, agent job management, provisioning security, installation, patching, and configuration
- Expert in TSQL
- SSAS (OLAP, Cube)
- Well versed in Dimensional Warehouses
- Broad understanding of Data Modeling, OLAP, SQL and ETL (SSIS, SSAS)
- Minimum of Bachelor’s degree in Computer Science, Information Technology, or equivalent work experience and at least 5 years as a data warehouse architect
- Understanding of PowerBI, SSRS
- Responsible for the conception, design, and development of the warehouse architecture and data models
- Provide leadership for the architectural direction.
- Work together with the team to develop data warehouse platform vision, strategy.
- Follow various ETL Processes to prepare design for all metadata
- Responsible for the development of physical and logical data models
- Ensure high-performance access to diverse data sources
- Enforce architectural constraints and reject designs which compromise system integrity
- Encourage the adoption of an organization’s frameworks by providing documentation, training, sample code, and developer support
- Communicate progress on the adoption and effectiveness of the developed frameworks to department head and managers.
- Understanding of Machine Learning and Predictive Analytics
- Communication skills: It is vital that applicants have exceptional written and spoken communication skills with active listening abilities to contribute in making strategic decisions and advise senior management on specialized technical issues, which will have an impact on the business
Preferred Skills
- Azure Data Lake
- Cosmos DB
- Synapse
- Snowflake
As the fastest growing commerce company in the industry, we offer the opportunity for tremendous upward mobility within the company as well as development and professional growth opportunities. FreedomPay's fulltime roles provide exceptional benefits including medical, prescription, dental and vision coverage, Life Insurance, Retirement Plans with company match, commission sharing plan, flexible hybrid working environment, and great parental and other leave programs. All positions must be able to successfully pass a background check as well as a credit check.
