About Ascendion
About Ascendion
Ascendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power growth and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. Headquartered in New Jersey, our workforce of 6,000+ Ascenders delivers solutions from around the globe. Ascendion is built differently to engineer the next.
Ascendion | Engineering to elevate life
We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:
- Build the coolest tech for the world s leading brands
- Solve complex problems and learn new skills
- Experience the power of transforming digital engineering for Fortune 500 clients
- Master your craft with leading training programs and hands-on experience
Experience a community of change makers!
Join a culture of high-performing innovators with endless ideas and a passion for tech. Our culture is the fabric of our company, and it is what makes us unique and diverse. The way we share ideas, learning, experiences, successes, and joy allows everyone to be their best at Ascendion.
About the Role
- Job Title:Data Architect
- Location: Remote
SQL Data Architect
Summary:
The SQL Data Architect is responsible for the strategic design, development, and maintenance of scalable, secure, and high-performing data architectures and database systems, primarily within a SQL environment. This role involves translating business requirements into technical data solutions, ensuring data integrity, optimizing data accessibility, and overseeing end-to-end data migration activities for various applications and analytical needs. Experience in finance or bookkeeping domains will be a plus.
Key Responsibilities:
- Data Architecture Design:
Design and develop conceptual, logical, and physical data models for relational databases, data warehouses, and other data stores using SQL-based technologies. - Database Development & Optimization:
Create, implement, and optimize database structures, schemas, stored procedures, functions, and views in SQL Server or other relevant SQL platforms. - Data Integration, ETL & Migration:
- Design and implement robust Extract, Transform, Load (ETL) processes to integrate data from diverse sources into the data architecture.
- Lead and execute data migration activities, including data mapping, cleansing, transformation, validation, and cutover planning for system upgrades, cloud migrations, and application transitions.
- Ensure minimal downtime and high accuracy during migration cycles.
- Documentation:
Create comprehensive documentation for data architecture, data models, technical specifications, data flow diagrams, and data migration plans. - Technology Evaluation:
Evaluate and recommend new database technologies, tools, and best practices to enhance the data infrastructure, including modern data migration tools and platforms.
Technical Expertise:
- In-depth expertise in SQL and proficiency with relational database management systems (RDBMS) like SQL Server, Oracle, MySQL, or PostgreSQL.
- Strong understanding of data modeling principles and techniques (e.g., Kimball, Inmon).
- Experience with ETL tools and processes.
- Hands-on experience with data migration frameworks and tools (e.g., SSIS, Azure Data Factory, AWS DMS, custom scripting).
- Knowledge of data warehousing concepts and OLAP.
- Familiarity with cloud-based data platforms (e.g., Azure SQL Database, AWS RDS) is a plus.
- Strong analytical and problem-solving capabilities to identify data-related issues and develop effective solutions.
Salary and Other Compensation:The annual [salary/hourly rate] for this position is between [$140,000 $145,000 annually]. Factors which may affect pay within this range may include geography/market, skills, education, experience and other qualifications of the successful candidate.
Benefits:The Company offers the following benefits for this position, subject to applicable eligibility requirements: [medical insurance] [dental insurance] [vision insurance] [401(k) retirement plan] [life insurance] [long-term disability insurance] [short-term disability insurance] [paid parking/public transportation] [xx days/hours of paid time off] [xx days/hours of paid sick and safe time] [xx days/hours of paid vacation time] [xx weeks of paid parental leave] [x paid holidays annually] [add others as needed- include all material benefits available to the position]
Want to change the world? Let us know.
Tell us about your experiences, education, and ambitions. Bring your knowledge, unique viewpoint, and creativity to the table. Let s talk!
Never miss an opportunity! Create an alert based on the job you applied for.
