Data Solutions ArchitectLighthouse Technology Services • Buffalo, NY, United States
Data Solutions Architect
Lighthouse Technology Services • Buffalo, NY, United States
[job_card.variable_days_ago]
[job_preview.job_type]
- [job_card.temporary]
[job_card.job_description]End-to-end solution architectures for data platforms, including detailed diagrams, technology stack specifications, and integration patterns. ETL / ELT pipeline designs and implementation plans for onboarding new data sources and modernizing legacy systems. Data governance frameworks, including policies for data quality, lineage, and access control, aligned with Enterprise Architecture standards. Technical documentation packages : architecture blueprints, operational runbooks, and security protocols. Prototypes and proof-of-concept implementations demonstrating new data engineering capabilities (e.g., streaming analytics, automated data quality checks). Performance benchmarks and scalability assessments for deployed solutions. Risk mitigation plans, including security audit findings and disaster recovery strategies. Bachelor's or Master's degree in Computer Science, Engineering, or a related field. 5+ years of experience in solution architecture or technical implementation, including 2+ years in data engineering or enterprise data platforms. Relevant certifications such as AWS / Azure Solutions Architect or Certified Data Engineer. Hands-on experience with cloud platforms such as Azure, AWS, or GCP. Proficiency in cloud-native development, including microservices and Kubernetes. Experience with API design (REST) and integration frameworks (ETL / ELT). Strong knowledge of data modeling, data pipeline orchestration, metadata management, and data lifecycle practices. Familiarity with data lakes, data warehouses, and lakehouse architectures. Experience with real-time and batch data processing, data integration, and automation. Understanding of financial systems such as payment networks, liquidity management, and settlement processes. Working knowledge of global data privacy and compliance standards (e.g., GDPR, CCPA). Familiarity with security practices including data encryption, access controls, and penetration testing. Strong analytical problem-solving abilities for complex data systems. Proven leadership in Agile / DevOps environments, including CI / CD pipelines and infrastructure-as-code. Proficiency with project management and collaboration tools such as Jira. Demonstrated success deploying scalable financial systems such as digital wallets, payment gateways, or blockchain-based platforms.
Lighthouse Technology Services is partnering with our client to fill their Data Solution Architect position! This is a 12+ month contract opportunity based in Buffalo, NY and is open to local and remote candidates. If outside of Buffalo, the Solution Architect will travel to Buffalo every 4-6 weeks (Mon-Thurs in office). This role will be a W2 employee of Lighthouse Technology Services.
Position Overview :
The Data Solution Architect is responsible for designing and delivering enterprise-grade data platforms and solutions that enable advanced analytics and business intelligence. This role requires deep expertise in data engineering, cloud-native architecture, and modern data technologies. The architect will work closely with engineering, product, and compliance teams to build secure, scalable, and regulatory-compliant data solutions. All solutions must align with the principles, standards, and reference architectures established by the Enterprise Architecture function, ensuring consistency, interoperability, and strategic fit across the organization.
What You'll Be Doing :
- Architect and deliver cloud-based data platforms and scalable data pipelines (e.g., Azure Data Lake, Databricks, Kafka).
- Develop and implement ETL / ELT frameworks to ingest, transform, and integrate data from diverse sources.
- Design and deploy data warehouses, lakehouses, and analytics environments supporting Power BI and Snowflake.
- Define and enforce standards around data governance, quality, metadata, and compliance.
- Collaborate with Enterprise Architecture to align solutions with strategic reference models and standards.
- Lead evaluations and proof-of-concepts for emerging data technologies and architectures.
- Produce deliverables including architecture diagrams, data flow maps, security models, and documentation.
- Guide Agile / DevOps teams through CI / CD pipelines, automated testing, and infrastructure-as-code implementations.
Expected Deliverables :
What You'll Need to Have :
Pay Range : $53-$63+ / hr
Questions about any of our jobs? Email us at recruiting@lhtservices.com
View all of our open jobs here : jobs.lhtservices.com
[job_alerts.create_a_job]
Solution Architect • Buffalo, NY, United States
[internal_linking.similar_jobs]
Buffalo, NY or Wilmington, DE (3 days onsite / 2 days remote), OR Remote w / travel.Will be expected to travel to Buffalo, NY and / or Wilmington, DE every 4-6 weeks with Monday through Thursday in offi...[show_more]
Solution Architect Job Duties : Responsible for assisting in the establishment of an IT Archit...[show_more]
Minimum of 6+ years of experience in IT Industry.Creating data models, building data pipelines, and deploying fully operational data warehouses within Snowflake.
Writing and optimizing SQL queries, ...[show_more]
Salary : $55,000 - 80,000 per year.Excellent planning, mapping, and communication skills combined with client interaction, enabling you to make immediate decisions based on new information.An affini...[show_more]
At EY, we're all in to shape your future with confidence.We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.Join EY and help ...[show_more]
Your Opportunity as the Senior Analyst, IS Support Services.As a Support Services team member, you provide insightful advice and friendly technical support to users in need.You quickly diagnose har...[show_more]
Performs research and analysis of complex healthcare claims data, pharmacy data, and lab data regarding network utilization and cost containment information.
Evaluates, writes, and presents healthca...[show_more]
Must be open to coming onsite once every other month •.All expenses paid by the customer.We are supporting a large-scale Epic Community Connect implementation for a confidential healthcare customer ...[show_more]
Remote Opportunity : Link Posting Marketing Rep (No Experience Needed!) Are you self-driven, reliable, and ready to earn from anywhere? We’re looking for motivated individuals to jo...[show_more]
Who You'll Work With In our Salesforce business, we help our clients bring the most impactful customer experiences to life and we do that in a way that makes our clients the hero of their transfor...[show_more]
Buffalo, NY (Hybrid 3 Days Onsite).The manager wants to know if we have anyone that knows ServiceNow Virtual Agent.Below I have listed the skill set for this project : .
The position will require at l...[show_more]
A career in IBM Consulting is rooted by long-term relationships and close collaboration with clients across the globe.You'll work with visionaries across multiple industries to improve the hybrid c...[show_more] Information Architect Job Duties : Identifies user requirements by researching and analyzing user needs, ...[show_more] 
Maximus is searching for an Analyst - Prog Support.Position is contingent upon contract award •.Must have the ability to pass a federal background check.
Equipment will be provided but must meet the ...[show_more]
We are seeking an experienced and innovative Data Architect to lead the design, development, and optimization of our enterprise data architecture.
This individual will play a critical role in aligni...[show_more] At EY, we're all in to shape your future with confidence.We'll help you succeed in a globally connected powerhouse of diverse teams and take your career wherever you want it to go.Join EY and help ...[show_more] 
At PwC, our people in data and analytics focus on leveraging data to drive insights and make informed business decisions.
They utilise advanced analytics techniques to help clients optimise their op...[show_more] At PwC, our people in data and analytics engineering focus on leveraging advanced technologies and techniques to design and develop robust data solutions for clients.
They play a crucial role in tra...[show_more]
Data Solution Architect
Syntricate Technologies • Buffalo, NY, United States
[job_card.temporary]
[last_updated.last_updated_variable_days] • [promoted]
Solution Architect
TradeJobsWorkForce • 14263 Buffalo, NY, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Snowflake Architect
United IT Solutions • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Software Implementation Consultant
Odoo, Inc. • Buffalo, New York, United States
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Customer Tech - Salesforce Solution Architect Manager - Tech Consulting - Open Location
EY • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Analyst, IS Support Services
The J. M. Smucker Company • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Senior Analyst, Healthcare Analytics (Marketplace) - REMOTE
Molina Healthcare • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Epic Cupid Analyst
TEKsystems • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_1_day] • [promoted]
Work from Home
HomeJobFinder • Lewiston, NY
[filters.remote]
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Salesforce Public Sector Solutions Lead - Enterprise
Slalom • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Reporting & Analytics Analyst
Syntricate Technologies • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Oracle Cloud SCM Consultant - OM Management
IBM • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Information Architect
TradeJobsWorkForce • 14207 Buffalo, NY, US
[job_card.full_time]
[last_updated.last_updated_30] • [promoted]
Analyst - Prog Support
MAXIMUS • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
Data Architect
Novocure Inc • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_1_day] • [promoted]
Data Architect - Power & Utilities - Senior Manager- Consulting - Location OPEN
EY • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]
Managed Services - IBM MDM (Master Data Management) Developer - Senior Associate
PwC • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_days] • [promoted]
GenAI Python Systems Engineer - Experienced Associate
PwC • Buffalo, NY, United States
[job_card.full_time]
[last_updated.last_updated_variable_hours] • [promoted] • [new]