• Anywhere

Recovery Centers of America at King of Prussia

Full-time Position


Recovery Centers of America is on a mission to save 1,000,000 lives one neighborhood at a
time providing treatment for addiction and mental health disorders that is as affordable and as
accessible as treatment for other diseases. When you have an unrelenting passion for what
you do, it isn’t a job, it’s a calling. A career in recovery is motivating, inspiring, and rewarding.
RCA is looking for a Data Architect, specializing in ETL, database administration, and data
modeling. The role is responsible for enforcing enterprise standards, best practices and
development of conceptual, logical, and physical models for the Data Warehouse. In working
with BI staff and business users, this position will be responsible for the build out of scalable and
robust data marts and the core data warehouse.
Job Responsibilities:
● Design EDW data models. Create the logical design.Translate the logical design into the
physical / SQL data model
● Consider both back-end organisation of data and front-end accessibility for front end
queries / BI Developers
● Program and configure the data warehouse to provide support to business information
● Optimize the physical design to meet system storage / performance requirements
● Install and test new versions of the database management system (DBMS), ETL tools,
● Maintain data standards, including adherence to the HIPPA Data Security Requirements
● Configure, deploy and troubleshoot necessary data warehouse tools (e.g. Modeling
● Evaluate and assess client requirements and design, model and implement data
warehouses, data marts and other analytical structures (e.g. OLAP cubes) if needed
● Responsible for completion of tasks from inception to post implementation.
● Gathers, and documents business requirements and ensures that overall design is
completed correctly and in line with established guidelines and business needs.
● Design BI data models based on EDW data model
● Use ETL tools, such as SSIS to provide data integration solutions.
● Map data from source systems, restructure, and integrate as necessary.
● Perform data governance and quality and testing analysis, including data profiling and
solution testing
● Write database documentation, including data standards, procedures and definitions for
the data dictionary
● OS administration, and storage management knowledge & capabilities
● Access disparate data and apply internal and external business rules, policies and data
quality measures
● Insure the data is safely and securely transferred to target destinations
● Troubleshoot EDW / BI tools, systems and software;
● Performance-tune EDW / BI tools, systems and software necessary.
● Potential for periodic on-call duty supporting these applications and services
● Design error-processing routines
● Create/manage batch processes
● Provide project estimates, plans, and schedules
● Analyze, develop, install, test, upgrade, maintain and support complex data/process
models, and processes in an ETL environment
● Develop; Stored Procedures, Reporting Design, Report Modeling, Databases,
Administration and Automation of BI solutions
● Design analytic applications with business users, including wireframe for initial functional
requirements analysis
● Design and implement BI security model
● Data verification & Unit testing of dashboards
● Complete dashboard deployment and system testing
Required Skills:
● 3 to 5+ years of SQL Server, Transact SQL, and SSIS experience or certifications in
these technologies
● 3 to 5+ years of design, architecture and development experience, including planning,
analysis, design, implementation, code review and maintenance
● 3 to 5+ years of ETL design, development, and performance tuning
● Testing and development coordination
● Excellent verbal and written communication skills
● Proven experience of implementing solutions from requirements gathering and process
design to functional production deployment
● Demonstrated ability to produce high quality deliverables
● Strong knowledge of emerging technologies and tools
● Strong communication skills and ability to actively contribute to a high-level Business
Intelligence team