Data Architect

Precise Software Solutions, Inc. is seeking a highly skilled and experienced Data Architect to join our team. As a Data Architect, you will play a crucial role in designing and implementing efficient data solutions for our large, highly transactional enterprise system. Your primary responsibilities will revolve around designing cloud databases and developing robust Extract, Transform, Load (ETL) processes. The ideal candidate will have a strong background in enterprise database design, ETL, and cloud technologies.

Join our team as a Data Architect and contribute to the success of our enterprise system by designing scalable and high-performing cloud database solutions. Apply your expertise in ETL development and enterprise database design to drive the organization's data architecture and ensure the availability and reliability of critical data assets.

Domain experience with federal government customer organizations and programs is strongly preferred so the successful candidate can hit the ground running. Must have experience with large transactional database design. 

The position is remote but requires location in the Eastern or Central U.S. time zone. 

Qualified candidates must have or can attain a Public Trust clearance.

DUTIES AND RESPONSIBILITIES

• Design and implement cloud database solutions: You will be responsible for architecting and implementing scalable, reliable, and secure cloud database solutions. This includes analyzing data requirements, selecting appropriate database technologies, and designing efficient data models that align with the organization's objectives.
• Develop ETL processes: You will design and develop robust ETL processes to extract data from various sources, transform it to meet business needs, and load it into the cloud database. This involves working closely with stakeholders to understand data integration requirements and ensuring the accuracy and timeliness of data transformations.
• Optimize data performance: You will fine-tune database performance by optimizing data structures, indexing strategies, and query execution plans. Additionally, you will identify and resolve performance bottlenecks to ensure optimal system performance.
• Ensure data integrity and security: You will implement appropriate data governance practices, data quality controls, and security measures to safeguard sensitive information. This includes defining data access controls, encryption mechanisms, and disaster recovery strategies.
• Collaborate with cross-functional teams: You will work closely with software engineers, data scientists, business analysts, and other stakeholders to understand their data needs and provide them with reliable, consistent, and accessible data solutions. Effective communication and collaboration skills are essential.
• Collaborate with customers, stakeholder and development teams and conduct technology assessments
• Operate across organizational and computing “silos” to drive common approaches and expose information assets and processes across the organization
• Define and implement data architecture for diverse business processes, projects, and function
• Provide technical support and training of an organization’s IT personnel to ensure high level of business performance
• Ensure proper documentation of data design and developing processes in order to produce appropriate procedures for application use
• Design databases according to specific architectural design to improve overall system performance

REQUIREMENTS

• Proven experience in enterprise database design and optimization, including data modeling, schema design, and performance tuning
• Strong expertise in ETL development, data integration, and transformation processes
• Hands-on experience with cloud platforms such as AWS, Azure, or Google Cloud, including database services like Amazon RDS, Azure SQL Database, or Google Cloud SQL
• In-depth knowledge of relational databases (e.g., Oracle, SQL Server, PostgreSQL) and proficiency in SQL programming
• Familiarity with NoSQL databases (e.g., MongoDB, Cassandra) and big data technologies (e.g., Hadoop, Spark) is a plus
• Understanding of data governance, data security, and compliance requirements
• Excellent problem-solving skills and the ability to work in a fast-paced, dynamic environment.
• Strong analytical and critical thinking abilities to analyze complex data scenarios and provide effective solutions

OTHER REQUIREMENTS/QUALIFICATIONS

• Ability to obtain, at a minimum, Public Trust clearance
• Bachelor’s degree from an accredited college in computer science, engineering, business, management, or a related discipline, or equivalent experience/combined education, with 10+ years of professional experience; or 8+ years of professional experience with a related Master’s degree
• 10+ years of experience in related fields
• Broad IT industry knowledge, deep expertise in one or more technical areas: User experience, SOA, microservices, enterprise service bus, database design, access and identity management, high availability infrastructure, Cloud, DevSecOps etc.
• Exemplary oral, written, interpersonal communication and customer service skills.
• Able to produce results within a collaborative environment
• Highly organized and deadline-driven; able to multitask
• Interest in working as part of a small and growing company, with awareness about the opportunities and challenges that come with a highly adaptive environment

ABOUT US

Precise Software Solutions, Inc., an SBA 8(a) program participant, is an innovative small business with a proven record of success delivering quality services and solutions to government organizations. A CMMI Level 3 company, Precise serves as a trusted advisor to senior technology executives and helps government agencies enhance and expand their information technology capabilities. Precise helps their customers capitalize on the efficiencies offered by technological advancements and ensures the integrity of their IT systems and programs so they can perform their public mission more effectively. The company is known for delivering agile and innovative solutions and specializes in strategic consulting, system modernization and integration, digital transformation and experience, infrastructure and cloud implementation, and data management and analytics.

BENEFITS AND PERKS: 

• Comprehensive Health Benefits (Medical, Dental and Vision) including High Deductible Health plan where company pays 100% of the deductible for your family.
• Flexible Spending Accounts (FSA) & Health Savings Account (HSA) 
• Retirement Plan with 4% match and discretionary match at year end
• Paid Time Off (PTO): 15 days of PTO accrued per year; 7 holidays+ 3 Floating holidays; 2 Innovation days (paid training days)
• Short Term and Long-Term Disability
• Paid Parental Leave
• Paid Jury Duty leave 
• Life and AD&D Insurance 
• Critical Illness Insurance
• Training and Development 
• Wellness Incentives & Discount programs
• Employee Referral Program 
• Annual Charity Donation Match 
• Awards and Recognition

Our Equal Employment Opportunity Policy

Precise is an equal opportunity employer. The company shall not discriminate against any employee or applicant because of race, color, religion, creed, sex, sexual orientation, gender or gender identity (except where gender is a bona fide occupational qualification), national origin, age, disability, military/veteran status, marital status, genetic information or any other factor protected by law. We are committed to equal employment opportunity in all decisions related to employment, promotion, wages, benefits and all other privileges, terms and conditions of employment. The company is dedicated to seeking all qualified applicants.