Ssrs jobs in Bayonne, NJCreate job alerts

Job Description Job Title/Role:-Solutions Architect (MS Dynamics CRM) Location:-New York City,NY Duration:-6 Months Visa:-Any Interview:- Phone/Skype Mandatory Skills ⦁Microsoft Dynamics CRM, .NET assemblies, SQL Server, JavaScript Validation Detailed JD ⦁Microsoft Dynamics CRM technical consultants with experience in CRM. ⦁Hand on expertise in Customization of Microsoft dynamics CRM 2016 and D365(Online). ⦁Experience covering Design, development, implementation and post production support knowledge. ⦁Must have production support experience for a multi-location development team structure. ⦁Should have hands on experience in design & development of .NET assemblies, plug- ins, .NET web services and custom workflows. ⦁SQL Server working knowledge of designing/ deploying SSRS custom reports / dashboard, specifically with Dynamics CRM entities. ⦁Experience in writing Java Script Validation for various Entity Forms. ⦁Understand the functional design based on business requirement.

Job DescriptionBenefits: • 401(k), • 401(k) matching Leads the effort in database management through data modeling. Expert in setting up Microsoft SQL Server database in virtual and clustered environments, along with experience in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS). Key Requirements Serve as key member of the database team managing all operations consistent with database management. Ability to perform and troubleshoot SQL Server Backups, Restore Strategies, Replication, SQL Server Performance Tuning and Query Optimization. Experience: 8+ years Certifications: N/A Technologies: SQL Server 2014/2016/2019, SSIS packages, DB2, OLAP and OLTP Data modeling with the ERWIN data modeling tool

Job Description This job opportunity is part of an RFP process; candidates are invited to submit their resumes detailing relevant experience. Location: New York City (Hybrid, 2-3 days per week onsite) Required Clearance: Public Trust LCG is a minority-owned technology consulting firm that has been a trusted partner to more than 40 federal agencies, including 21 of the 27 Institutes and Centers (ICs) at the National Institutes of Health (NIH). For over 25 years, LCG has brought digitization and innovation to the Health and Human Services (HHS) and the NIH ecosystems. We support IT organizations by bringing precision technology and operation models that achieve mission capabilities and performance success. Position Description The DevOps Engineer will be responsible for designing, implementing, and maintaining scalable IT configurations and deployment pipelines. This is in support of a major initiative, aimed at migrating legacy DB2 databases to modern SQL-based infrastructure. The role requires expertise in cloud-native applications, Azure DevOps, CI/CD automation, and database migrations, ensuring seamless integration with the client’s existing systems. Key Responsibilities • Develop and maintain CI/CD pipelines for automated deployment of infrastructure and application updates., • Support the DB2 to SQL migration, ensuring data integrity, optimization, and seamless system transitions., • Configure and deploy SQL Server databases, ensuring integration with DOE's IT environment., • Optimize IT configurations to enhance security, reliability, and performance., • Automate configuration management using tools like Terraform, Ansible, and Chef., • Implement cloud solutions on Azure, supporting scalable DevOps practices., • Integrate DevOps workflows with Microsoft .NET applications, ensuring compatibility across modern web and mobile browsers., • Establish monitoring solutions using Power BI and SQL Server Reporting Services (SSRS) for system performance tracking., • 8+ years of experience in DevOps, system automation, and database migrations., • Strong proficiency in DB2 to SQL data migration tools and methodologies., • Expertise in Microsoft SQL Server (2014/2016/2019) and Azure Data Factory for seamless data integration., • Experience configuring and managing containerization with Kubernetes and Docker., • Deep understanding of Terraform, Ansible, and Chef for infrastructure automation., • Familiarity with Azure DevOps, GitLab CI/CD, and other pipeline orchestration tools., • AWS Certified DevOps Engineer or Microsoft Azure DevOps Engineer Expert., • Experience with SQL database administration, data modeling, and query optimization. The projected compensation range for this position is $120,000 - $150,000 per year benchmarked in the New York City metropolitan area. The salary range provided is a good faith estimate representative of all experience levels. Salary at LCG is determined by various factors, including but not limited to role, location, the combination of education/training, knowledge, skills, competencies, certifications, and work experience. LCG offers a competitive, comprehensive benefits package which includes health insurance options (medical, dental, vision), life and disability insurance, retirement plan contributions, as well as paid leave, federal holidays, professional development, and lifestyle benefits. Devoted to Fair and Inclusive Practices All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. If you are interested in applying for employment with LCG and need special assistance or an accommodation to apply for a posted position, contact our Human Resources department by email at . Securing Your Data Beware of fraudulent job offers using LCG's name. LCG will never request payment-related details or advancement of money during the application process. Legitimate communication will only come from lcginc.com or emails, not free commercial services like Gmail or WhatsApp. If you receive suspicious emails asking for payment or personal information, contact us immediately at . If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.

Job Description Job Title: Suicide Prevention Implementation Specialist Grade: 22 Salary: $79,116-$90,726 The Research Foundation for Mental Hygiene is seeking a qualified applicant to fill a full-time Suicide Prevention Implementation Specialist position for the Division of Behavioral Health Services and Policy Research at the New York State Psychiatric Institute. The Suicide Prevention -Training Implementation and Evaluation initiative (SP-TIE) Program at the New York State Psychiatric Institute is seeking a full-time Suicide Prevention Specialist to work on several federal- and foundation-funded grants on suicide prevention. This position requires on-site attendance. Partial remote schedule will be allowed. The ideal candidate will have with interest in mental health research and evaluation and experience working in community mental health settings. The ideal candidate will have a masters degree and be clinically-licensed or NYS license-eligible in a mental health field (e.g., social, mental health counseling, psychology, etc.). The Suicide Prevention Specialist will assist with a number of activities for a federally-funded youth suicide prevention grant (GLS MISSION; 1H79SM090035-01), as well as the general activities of the Suicide Prevention - Training, Implementation, and Evaluation (SP-TIE) Program at the Center for Practice Innovations, New York State Psychiatric Institute. Candidates must have strong organizational and communication skills - scheduling, managing team schedules, coordinating communication among various partners and stakeholders, keeping track of deadlines, following up to ensure timely completion of tasks, etc. Candidates must take initiative and work independently on multiple tasks under tight deadlines. Duties and Responsibilities: • Assist the principal investigator in coordinating programmatic, training, and clinical efforts and tracking project requirement deadlines for all participating entities of the MISSION grant, • Serving as a liaison between multiple collaborators and disciplines to ensure effective communication/coordination, • Assist in the development and coordination of clinical training activities, including planning, content development, and tracking participant registration and attendance, • Provide project management and implementation assistance for community and clinical partners participating in the MISSION Project, • Develop and maintain organizational and educational tools to ensure compliance with good research and clinical practices, • Cinical coordination and oversight, including but not limited to: scheduling participants; outreach; attending project trainings and wellness events; telephone or in-person screening and assessment; in-person, phone, or video-conferenced qualitative interviews; co-facilitating focus groups; qualitative coding and adherence/fidelity ratings (with training); recruitment activities across various behavioral health, school-based, and community environments; facilitating engagement/information exchange between participants and the SP-TIE team; assisting with case management/care coordination and clinical risk management as needed; and providing psychosocial support to and maintaining continual good communication with participants, families, clinical sites, and external collaborators., • Assist the grant evaluator with quantitative and qualitative clinical data collection and management from community and clinical partners, including creation and maintenance of project databases using RedCAP, Excel spreadsheets (including formulas/macros), SPSS (including syntax), and/or other statistical packages, • Provide administrative and technical support to Co-Directors in all aspects of their work, including (but not limited to):, • Training: Preparation of continuing education applications; assisting with evaluation development, content creation, and provision of trainings; and liaising with learning management system staff for all SP-TIE live/in-person and distance learning course offerings (webinars, modules, in-person trainings), including production of asynchronous learning modules, • Academic: Assist with conference presentations, writing manuscripts and grants, creating PowerPoint slides and graphics/charts/tabular data presentations, conducting literature searches on suicide prevention-related topics, • Research: Assist with production of quarterly and annual data reports, ongoing regulatory documentation, and preparation of IRB materials, • Administrative: Schedule, organize, and participate in meetings and conference calls related to SP-TIE program activities; preparation of materials and keeping meeting minutes as needed; assisting with budgeting, purchasing, and contracts, • Be proficient in the Microsoft Office suite and videoconferencing software, • Bachelor's degree in Psychology, Mental Health Counseling, Social Work or a related field, and at least (1) year of relevant clinical or research experience; or master's degree in Psychology, Mental Health Counseling, Social Work or a related field., • At least (1) year experience working in community mental health settings The preferred candidate will have (6) months or more experience with several of the following (in order of importance): • Suicidology, program evaluation, or implementation science, • Some training or experience using suicide prevention best practices, especially suicide screening (e.g., C-SSRS) and safety planning, • Provision of assessment or intervention services with youth or adults with suicidal ideation or behavior, • Preparation of data reports, regulatory documentation, and IRB materials, • Clinical research coordination or project management, • Quantitative data analysis and management, including: writing original Excel macros and SPSS syntax (or code in a similar statistical programming language), creating databases and forms in REDCap, Qualtrics, or similar programs; and conducting parametric and non-parametric statistical analysis, • Qualitative data coding/analysis (including NVivo) or adherence/fidelity coding, • Distance learning systems and/or development of eLearning trainings To Apply: Submit an application through our website at . Please note only applications submitted through our website will be considered. The Mission of the Research Foundation for Mental Hygiene, Inc. (RFMH) is to promote the mental health of all New Yorkers, with a focus on providing hope and supporting recovery for adults with serious mental illness and children with serious emotional disturbances. Applicants with lived mental health experience are encouraged to apply. RFMH is deeply committed to supporting underserved individuals, organizations, and communities. To this end, RFMH is focused on implementing activities and initiatives to reduce disparities in access, quality, and treatment outcomes for underserved populations. A critical component of these efforts is ensuring that RFMH is a diverse and inclusive workplace where all employees' unique attributes and skills are valued and utilized to support the mission of the Agency. RFMH is an equal opportunity/affirmative action employer. The Research Foundation is a private not-for-profit corporation and is not an agency or instrumentality of the State of New York. Employees of the Research Foundation are not state employees, do not participate in any state retirement system, and do not receive state fringe benefits. Excellent Benefits Package. Employer/Minority/Women/Disabled/Veteran Employer. VEVRAA 41 CFR 60-300.5(a) compliant. Job Posted by ApplicantPro

Job Description MetTel is a global communications solutions provider with the most complete suite of fully managed services that focus on secure connectivity, and network and mobility services. We simplify communications and networking for business and government agencies. Our customers include many of the Fortune 500, and Gartner recognizes us as an industry leader. We have the broadest portfolio of technology and integrated partnerships, as well as our private network, which we use to create tailored solutions design, deployment, and ongoing management, driving cost savings, efficiency, innovation, and the ability to focus on core objectives. We believe that each team member is a key to the success and sustainability of the group. In order to achieve this, we offer an environment where all professionals can grow and develop their skills and competencies, collaborate with diverse professionals, share knowledge and enjoy a rewarding career. We are seeking an accomplished Executive Director, SQL Infrastructure and Operations to lead our enterprise database infrastructure strategy and operations. This role is responsible for overseeing the design, implementation, optimization, and support of robust, secure, and scalable SQL environments across our multi-tenant and international footprint. This is a strategic and hands-on leadership position for a highly experienced database professional who thrives in complex environments and is passionate about data performance, reliability, and operational excellence. Key Responsibilities • Leadership & StrategyDevelop and execute a comprehensive roadmap for SQL infrastructure across cloud and on-premise environments., • Lead and mentor a global team of database engineers and administrators., • Align SQL operations with broader enterprise architecture and business objectives., • Infrastructure Management, • Oversee design and maintenance of highly available, multi-tenant SQL Server environments., • Ensure database systems are secure, compliant, and aligned with international data governance standards (e.g., GDPR, HIPAA)., • Drive standardization and automation of SQL infrastructure and operational processes., • Operations & Optimization, • Lead incident response and root-cause analysis for critical database issues., • Manage capacity planning, performance tuning, and cost optimization strategies across diverse workloads and geographies., • Define and monitor SLAs/OLAs, ensuring 24/7 availability and disaster recovery capabilities., • Oversee patching, backups, monitoring, and incident management, • Maintain infrastructure and database health through proactive monitoring and logging, • Collaboration & Communication, • Partner with application teams, DevOps, InfoSec, and business units to meet evolving data requirements., • Represent SQL Infrastructure in architectural reviews, audits, and executive discussions., • Bachelor's degree in Computer Science, Information Systems, or a related field (Master's preferred)., • 10+ years of hands-on experience managing enterprise SQL environments (SQL Server, Azure SQL, etc.)., • 5 years proven leadership and management experience with direct responsibility for global, multi-tenant database operations and support staff., • Proven experience managing IT infrastructure in a large-scale enterprise environment, including high-availability systems, disaster recovery planning, and performance tuning, • Expertise in high-availability architectures, replication, sharding, and disaster recovery strategies., • Strong experience with SQL Server tools (SSMS, SSIS, SSRS, etc.), cloud-based solutions (e.g., Azure, AWS RDS), and automation platforms (e.g., Terraform, Ansible, PowerShell)., • Familiarity with international compliance and data residency laws., • Excellent communication, leadership, and cross-functional collaboration skills., • Strategic Thinking and Execution, • ITIL certfication, • Certifications in database administration (Oracle, Azure, AWS, etc. a plus, • Experience with AWS/Azure Postgres, Databricks, Snowflake is a plus Competitive salary ranging from $150,000 - $200,000 commiserate based demonstrable experience. Keywords: SQL Infrastructure and Operations, Executive Director, SQL Infrastructure and Operations, Multi-Tenant, Multi-server, AWS, Azure, SQL Server, MetTel, Jobs Near Me, #JobsNearMe, Google, LinkedIn, Indeed, #LinkedIn, #Indeed, #SQLInfrastructureandOperations, #AWS, #Azure, #SQLServer, IT Systems and Databases MetTel is an Equal Opportunity Employer and considers applicants for all positions without regard to race, color, religion or belief, sex, age, national origin, citizenship status, marital status, military/veteran status, genetic information, sexual orientation, gender identity, physical or mental disability or any other characteristic protected by applicable laws. To learn more about our company visit us at

Job DescriptionDescription: The Morgan Library & Museum invites applications for the position of Collection Systems Specialist. Reporting to the Network Administrator in Management Information Systems, the Collection Systems Specialist is responsible for the optimum operation and development of the Morgan's ecosystem of databases supporting collection information, collection management, collection imaging, and the dissemination of collection data. Day-to-date responsibilities will also include documenting system administration processes, custom configurations, workflows and processes, and training super-users for each system. Responsibilities: · Manage the Morgan's core collection systems, including: The Museum System (TMS), its related application Conservation Studio (implementation in process), Voyager ILS, and ResourceSpace DAMs · Manage the Morgan's core collection database custom solutions (e.g. an Access-based Imaging & Rights Database and its Photo Studio extension); conceptualize and implement long-term strategies for data management · Manage the Morgan's ancillary custom collection management solutions (e.g. reader tracking, call slip and label printing, offsite storage management, etc.) with an eye to moving them to updated platforms as needed · Design and maintain custom reports for each system and across systems in order to meet user needs and supply institutional statistics (e.g. Crystal Reports, SSRS, SQL queries, dashboards, etc.); field and respond to user feedback on these reports · Model, implement, and manage data processes and integrations among the collection systems, including timed data refreshes; spearhead movement towards improved interoperability between the various collection systems · Write and maintain custom code to support the extraction and transformation of collection data to other platforms (e.g. website, union catalogs, specialized portals, etc.) · Contribute to strategic planning as it regards to system upgrades, migration, and integration · Advise on integration approaches to other types of data (ie. CRM) Requirements: • Bachelor's degree in computer science preferred, • Minimum three years of experience managing cultural heritage databases preferred, • Database administrator experience with MS SQL server required, • Knowledge of working with packages in SQL Server Management Studio (SSMS), SSIS/SSDT preferred, • Proficiency in writing SQL statements required, • Familiarity with Crystal Report and SQL Server Reporting Service (SSRS) preferred, • Knowledge of one or more high-level programming languages required; additionally, familiarity with Visual Basic (VB) preferred, • Understanding of metadata standards, data models, and data encoding related to cultural heritage information, such as JSON, MARC, MARCXML, EAD, IIIF, RDF/Linked Data preferred, • Diplomatic and clear verbal and written communication skills, • Strong organization skills to effectively manage multiple projects, • Ability to establish excellent working relationships with stakeholders and end users, • Ability to lift 40 lbs. of computer equipment. Able to climb, kneel, and crawl through narrow spaces for hardware installs and network cabling. Important to note: Vaccination Requirement To ensure the overall health and safety of the Morgan Library & Museum campus, all staff of the Morgan are required to be fully vaccinated against the virus that causes COVID-19, absent qualifying exemptions for medical, religious, or other reasons in accordance with applicable laws. EEO Statement The Morgan is an Equal Opportunity Employer and is committed to complying with all federal, state, and local equal employment opportunity laws. The Morgan provides equal employment opportunities to all employees and applicants for employment without regard to race, color, creed, religion, sex, pregnancy, sexual orientation, gender identity or expression, national origin, age, dis ability, marital status, military or veteran status, domestic violence victim status or any other basis prohibited by applicable federal, state, and/or local laws.

Job Description Microsoft Power BI Developer (13396-1) Location: New York, NY Work Model: On-Site Employment Type: Contract Seniority Level: Mid-Senior Level Overview A leading firm in the insurance and reinsurance industry is seeking an experienced Microsoft Power BI Developer to design and deliver high-impact business intelligence solutions. This position is based in New York, NY, with a focus on developing dashboards and data models that enable data-driven decision-making. Hourly Pay Rate: $82/hour Visa Sponsorship: Not available Relocation Assistance: Not available Preferred Industry Background: Reinsurance Key Responsibilities * Design, develop, and deploy interactive dashboards and analytical reports using Power BI * Collaborate with stakeholders to gather requirements and translate them into actionable insights * Create and manage data models, perform transformations with Power Query, and write complex DAX expressions * Integrate data using Azure Databricks and dbt to create gold-level reporting objects * Develop and schedule Azure Analysis Services tabular models and implement security configurations * Validate and troubleshoot data, ensure quality, and optimize performance * Prepare technical documentation, including data sources, report specs, and processes Technical Skill Requirements * Power BI, Power Query (M Language), DAX, Power Apps, Power Pivot, Power View * Azure Databricks, Azure SQL Server, Azure Data Lake Analytics/Store, Azure Analysis Services (SSAS), SSRS * Experience working with SQL and relational databases * Familiarity with MongoDB, dbt, and Azure Automation Runbooks * BI tool experience a plus (e.g., IBM Cognos, Tableau, QlikView) * Proficient in designing paginated reports, subreports, drill-down and drill-through functionalities Must-Have Qualifications * Bachelor’s degree in Computer Science, IT, Data Science, or related field * Minimum 5+ years of experience in Power BI development * Strong knowledge of Azure cloud services and data warehousing * Experience with Databricks and dbt * Strong proficiency in Power BI, Power Query, DAX, and data modeling * Reinsurance industry experience preferred * Excellent analytical, communication, and problem-solving skills * Microsoft Power BI certification or similar is highly preferred Job Details * Experience Required: 10 years total (5+ years specific to Power BI) * Location: New York, NY * Work Model: On-site * Education Required: Bachelor’s degree * Visa Sponsorship: Not eligible * Relocation Assistance: Not available * Total Openings: 1 Company DescriptionDiverse Systems Group, LLC (DSG), is a minority-owned 8(a) firm that creates custom information technology and business solutions for government agencies, systems integrators and government contractors. Our experience and commitment to client relationships enables us to provide creative, innovative and cost-effective solutions. DSG is a premier provider of information technology and business solutions to government agencies, system integrators and government contractors. Our project management experience and commitment to client relationships enable us to provide creative and cost-effective solutions. DSG provides a wide range of services to industries to help them leverage the strengths of Information Technology to optimize their business performance and produce value-driven results. Our services deliver a total solution package designed to meet our clients complete business and technology needs. DSG approaches every engagement with one objective in mind ... to help our clients win and grow. Specialties / DSG Core Competencies: • Healthcare Information Management, • Healthcare Information Technology Discovery(HID), • Project/Program Managers, • Change and Configuration Managers, • Quality Assurance/Testers, • Network Security, • Database Developers and Administrators, • Information Assurance, • Web Development, • HelpdeskDiverse Systems Group, LLC (DSG), is a minority-owned 8(a) firm that creates custom information technology and business solutions for government agencies, systems integrators and government contractors. Our experience and commitment to client relationships enables us to provide creative, innovative and cost-effective solutions. DSG is a premier provider of information technology and business solutions to government agencies, system integrators and government contractors. Our project management experience and commitment to client relationships enable us to provide creative and cost-effective solutions. DSG provides a wide range of services to industries to help them leverage the strengths of Information Technology to optimize their business performance and produce value-driven results. Our services deliver a total solution package designed to meet our clients complete business and technology needs. DSG approaches every engagement with one objective in mind ... to help our clients win and grow.\r\n\r\nSpecialties / DSG Core Competencies:\r\n* Healthcare Information Management\r\n* Healthcare Information Technology Discovery(HID)\r\n* Project/Program Managers\r\n* Change and Configuration Managers\r\n* Quality Assurance/Testers\r\n* Network Security\r\n* Database Developers and Administrators \r\n* Information Assurance\r\n* Web Development\r\n* Helpdesk

Job Description ITnova is seeking a Web Application Developer to support and enhance engineering web applications. The ideal candidate will work on full stack development, integration, and support for .NET-based systems and enterprise tools. Location: Jersey City, NJ Work Type: Hybrid Responsibilities: • Perform services to maintain and enhance existing Engineering customized .Net applications., • Develop and maintain interfaces and integrations between various Engineering applications, including but not limited to data transfer using in-house or third-party web services, SQL Server ETL packages, SharePoint online data import and export, Azure Data Lake data import and export, and Esri GIS integration., • At the direction of the Authority and in coordination with the Application group Project Manager and Technical Lead, design, develop, test and deploy new custom applications, as required., • Maintain and support the SQL Server Report Services (SSRS) reports for Engineering applications., • Must possess a bachelor's degree from an accredited college in Computer Science or a related technical field., • Minimum 5 years strong demonstrated experience in web application full stack development using ASP.Net Web Forms and ASP.Net MVC., • Minimum 5 years strong demonstrated experience in C# programming with a strong understanding of object-oriented programming and design patterns., • Minimum 5 years strong demonstrated experience in developing frontend using HTML, CSS, JavaScript, and jQuery., • Minimum 2 years strong demonstrated experience in developing .NET applications with React.js as the frontend and Node.js as backend middleware or service layers., • Minimum 2 years strong demonstrated experience in database design and development in a Microsoft SQL Server environment including stored procedure, functions, and data modeling, proficient in Entity Framework or other ORM technologies., • Minimum 2 years strong experience developing or maintaining system integration interface, REST API, web services., • Minimum 1 year solid demonstrated experience with version control tools Git and Azure DevOps., • Minimum 1 year solid experience in report development using Microsoft SSRS., • Self-motivated with the ability to prioritize, meet deadlines, and manage changing priorities., • Advanced degrees are highly desirable., • Experience with AI API integration, knowledge of machine learning workflows and leverage pre-trained models is highly preferred., • Experience with UI/UX design in Figma or similar platform is highly preferred., • Experience with build/deployment pipelines and CI/CD processes is highly preferred., • Experience working in an Agile/Scrum development environment., • Experience in Python and Esri GIS data integration is preferred., • Experience with Enterprise Content Management solutions such as SharePoint or OpenText are preferred., • Familiarity with web security best practices and authentication frameworks (e.g., OAuth2, JWT), • Some exposure or knowledge developing or maintaining application in the Azure cloud environment., • Experience working with large public government agencies in construction industry, a plus.

Job DescriptionBenefits: • 401(k), • Competitive salary, • Opportunity for advancement, • Training & development Job Type: W2 Contract Role, Full Time, On Site. Role is tied to a multi-year project contract. Industry: Information Technology / Data Engineering About Us At Red Hill Consulting LLC, we are more than just consultantswe are problem solvers, innovators, and strategic partners. With expertise in IT, governance, risk management, compliance, and business transformation, we help organizations navigate complexity and drive meaningful change. Our team specializes in delivering tailored, high-impact solutions that empower businesses to optimize processes, enhance security, and leverage data-driven insights. Whether it's implementing cutting-edge technology, refining operational strategies, or ensuring regulatory compliance, we take a proactive, hands-on approach to solving challenges. Rooted in our core values of Integrity, Innovation, and Excellence, we foster a collaborative environment where expertise meets execution. Our clients span industries such as finance, healthcare, government, and technology, and we pride ourselves on delivering measurable results that drive sustainable success. About the Role We are seeking a highly skilled Cloud Data Engineer to join a leading clients enterprise data engineering team. In this role, you will be responsible for designing, building, and maintaining large-scale data platforms, pipelines, and analytics systems that enable data-driven decision-making across the organization. This is a multi-year consulting engagement focused on modernizing enterprise data infrastructure by leveraging advanced Azure cloud services, data warehouse solutions, and DevOps practices. You will collaborate with architects, engineers, and business stakeholders to design and implement scalable data solutions that support analytics, reporting, and cloud transformation initiatives. This position is ideal for a senior-level engineer who thrives in hands-on cloud engineering, enjoys solving complex data challenges, and has a proven track record with Azure Data Factory, Azure Synapse, and enterprise-scale cloud data ecosystems. Key Responsibilities • Data Pipeline Development: Design and build scalable, high-performing data pipelines using Azure Data Factory, Synapse, and Azure Data Lake, supporting both batch and streaming data ingestion., • Cloud Platform Engineering: Develop and maintain enterprise-scale data platforms leveraging Azure IaaS/PaaS services, ensuring performance, scalability, and security., • Data Warehousing Solutions: Architect and optimize SQL Server-based and cloud-based data warehouses, implementing best practices in data modeling and integration., • DevOps & Automation: Implement CI/CD processes, infrastructure as code, and automation for seamless deployments and environment management., • Cross-Platform Expertise: Integrate solutions across Azure, AWS, and hybrid environments, providing architectural input for data movement and transformation strategies., • Advanced Analytics Enablement: Support downstream analytics platforms (Power BI, Azure Databricks, Spark, HDInsight) by designing efficient data structures., • Security & Compliance: Develop robust data security models and enforce governance across data pipelines and storage systems., • System Troubleshooting: Monitor and optimize pipelines, resolve performance bottlenecks, and troubleshoot complex data engineering issues., • Collaboration & Mentorship: Partner with stakeholders, guide junior engineers, and provide technical leadership throughout the project lifecycle., • Documentation & Training: Maintain comprehensive system documentation and deliver training for engineering teams and business users. Qualifications & Skills Education & Experience: • Bachelors degree in Computer Science, Engineering, or a related field., • 12+ years of experience in designing and developing enterprise-scale data warehouses and analytics systems in both cloud and on-premises environments., • Proven expertise in Azure cloud data services: Azure Data Factory, Azure Synapse, Azure SQL, Azure Data Lake, Azure Pipelines, and related IaaS/PaaS offerings., • Strong background in data modeling (Kimball and Inmon), ETL/ELT development, and pipeline orchestration., • Experience developing NoSQL solutions with Azure Cosmos DB and integrating with streaming data sources., • Proficiency in SQL Server (SSIS, SSAS, SSRS), T-SQL development, and query optimization., • Experience with DevOps, CI/CD pipelines, and Infrastructure as Code (IaC) practices., • Knowledge of Azure Databricks, Spark, IoT, and HDInsight is highly desirable., • Hands-on experience with C#, PowerShell scripting, and Python., • Strong understanding of data security models and compliance standards., • Excellent communication and stakeholder engagement skills, capable of working with both technical and business teams., • Strong analytical and problem-solving mindset with attention to detail., • Ability to mentor and lead junior engineers while delivering hands-on solutions., • Be part of a dynamic, mission-driven team that values innovation and strategic thinking., • Work on diverse, high-impact projects across multiple industries., • Opportunities for professional development and career growth., • Competitive salary and benefits package.

Job Description This job opportunity is part of an RFP process; candidates are invited to submit their resumes detailing relevant experience Onsite Requirement: A couple of days onsite required and travel to different sites. Job Summary: LCG is seeking an experienced Data Architect, Senior to support the modernization of the client Applicant and Administrator Applications. This project involves replacing outdated systems built with DB2 and .NET frameworks with a new, scalable, modern solution. The Data Architect will play a key role in designing and implementing a robust data architecture that enables seamless integration across legacy and new client systems, with a strong focus on DB migration experience, database architecture, and moving from DB2 to SQL Server using both manual and automated methods including Azure Database Migration Service and Azure Migrate. Key Responsibilities • Led end-to-end database migration initiatives, transitioning enterprise systems from IBM DB2 to Microsoft SQL Server. This included both manual and automated migration strategies using tools such as Azure Database Migration Service and Azure Migrate., • Architect and implement the full data lifecycle from ingestion to reporting, including staging, Operational Data Store (ODS), Data Mart, and Data Warehouse (DWH)., • Designing and implementing scalable and secure database architectures to support enterprise-grade applications and analytics., • Overseeing the full data migration lifecycle—from assessment and planning to execution and validation—ensuring data integrity, minimal downtime, and compliance with governance standards., • Developing and optimizing ETL processes using SQL Server Integration Services (SSIS) and Azure Data Factory to support seamless data transition and integration., • Creating and validating reports using SQL Server Reporting Services (SSRS) and building advanced dashboards and visualizations in Power BI to support business stakeholders during and post-migration., • Utilizing data modeling tools such as ERWin and ER/Studio to document and optimize relational models in the target SQL Server environment., • Supporting post-migration performance tuning, validation, and cloud optimization leveraging Microsoft Fabric and Azure-native services., • Design and oversee the development of Extract, Transform, Load (ETL) pipelines to support the integration of data across a mix of legacy and distributed systems., • Lead DB model design and staging strategies to enable scalable, governed data pipelines., • Lead the migration of data from legacy DB2 systems to modern SQL Server environments., • Collaborate with application developers, business analysts, and system architects to ensure accurate data modeling, mapping, and alignment with business rules., • Design and maintain enterprise data models using tools such as ER/Studio or ERwin., • Create scalable and secure data structures to support real-time and batch reporting needs, using SQL Server Reporting Services (SSRS) and Power BI., • Working in a tech stack of DB2, SQL Server, SSRS, SSIS, Power BI, Azure Data Factory, Microsoft Fabric, ERWin, ER/Studio, Azure Migrate, Azure Database Migration Service., • Define data pipeline governance, quality, and security standards for all new data architectures in compliance with client standards., • Ensure seamless data synchronization across DOE divisions (e.g., Payroll, HR, etc) and external systems., • Develop and enforce best practices for SQL tuning, indexing, database performance, indexing, data archiving, and ETL operations., • Provide mentorship and code review for ETL developers and data engineers., • Experience: Minimum of 7 years of experience in data architecture and integration in large-scale enterprise environments., • Microsoft SQL Server Data Tools (SSDT), • SQL Server Reporting Services (SSRS), • Microsoft Visual Studio, • Data modeling tools such as ER Studio or ERwin, • Power BI for report visualization, • PLSQL, • DB migration experience from DB2 to SQL Server (manual, automated, using tools like Azure Migrate and Database Migration Service), • DB model design, reporting logic, indexing, and SQL tuning, • Deep knowledge of ETL architecture principles and tools., • Strong experience modernizing legacy systems and migrating databases (preferably from DB2 to SQL Server)., • Experience integrating transactional systems with data warehouses and reporting platforms., • Demonstrated ability to architect solutions that scale to meet performance and data integrity requirements., • Experience with public sector modernization projects, preferably in education or large government agencies., • Familiarity with cloud-based data solutions (Azure SQL, Synapse, etc.) a plus., • Understanding of application modernization within Microsoft .NET environments. The projected compensation range for this position is $140,500 to $177,400 per year, benchmarked in the New York area. The salary range provided is a good faith estimate representative of all experience levels. Salary at LCG is determined by various factors, including but not limited to role, location, the combination of education/training, knowledge, skills, competencies, certifications, and work experience. LCG offers a competitive, comprehensive benefits package which includes health insurance options (medical, dental, vision), life and disability insurance, retirement plan contributions, as well as paid leave, federal holidays, professional development, and lifestyle benefits. Devoted to Fair and Inclusive Practices All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. If you are interested in applying for employment with LCG and need special assistance or an accommodation to apply for a posted position, contact our Human Resources department by email at . Securing Your Data Beware of fraudulent job offers using LCG's name. LCG will never request payment-related details or advancement of money during the application process. Legitimate communication will only come from lcginc.com or emails, not free commercial services like Gmail or WhatsApp. If you receive suspicious emails asking for payment or personal information, contact us immediately at . If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.

Job Description Job Title: Database Developer, Senior Onsite Requirement: A couple of days onsite required and travel to different sites. Job Summary: LCG is seeking a Database Developer, Senior to support an Applications Modernization Project. This position involves designing and building modern, scalable, and secure SQL Server databases to replace legacy DB2 systems. The ideal candidate will play a key role in creating robust data structures, writing optimized queries, ensuring data integrity, and contributing to system integration and performance improvements. The Database Developer, Senior will collaborate with application developers, system architects, business analysts, and client stakeholders to modernize the data infrastructure for both the Applicant and Administrator applications used in the client programs. Key Responsibilities • Design, develop, and implement SQL Server databases to replace existing DB2-based structures., • Create scalable database schemas to support modern web-based .NET applications across devices and browsers., • Write, test, and optimize SQL queries, stored procedures, triggers, and functions for high performance and reliability., • Utilize Redis where appropriate for fast-access, in-memory data storage to support web application responsiveness., • Perform ETL operations to migrate and transform legacy data into the new SQL database structures., • Utilize PLSQL where applicable to support migration or integration tasks., • Develop and maintain database maintenance plans and jobs, including indexing and statistics updates., • Ensure database integrity, security, and compliance with DOE’s data protection standards., • Conduct database performance tuning, SQL tuning, and optimization activities to support peak hiring periods., • Develop and implement advanced reporting logic to support critical business functions., • Implement and manage data backup, disaster recovery, and auditing strategies., • Support integration of the new database system with existing DOE systems (e.g., Payroll, Collections)., • Integrate with DOE systems and services such as IBM Security Access Manager (ISAM – OpenID/OAuth 2.0), DOE RBAC, IBM AP Connect, IBM Integration Bus (IIB), and SFTB, • Collaborate with the DevOps team to implement continuous integration and deployment (CI/CD) practices for data layers., • Participate in reporting requirements, creating both ad hoc and standardized reports using SQL Server Reporting Services (SSRS) and Power BI., • Utilize REST APIs for secure and scalable data integration across internal DOE platforms., • A minimum of 7+ years of experience in database development, with a strong focus on Microsoft SQL Server (2014/2016/2019)., • Proficient in SQL Server Data Tools, SSRS, and Power BI., • Strong understanding of data modeling, schema design, and performance optimization techniques., • Experience migrating from legacy systems (DB2) to SQL Server in a large-scale public sector or enterprise environment., • Demonstrated ability to work in Agile or hybrid Agile environments, collaborating with cross-functional teams., • Knowledge of security best practices and data privacy standards in public sector environments., • Excellent problem-solving skills and the ability to manage multiple priorities in a fast-paced environment., • Experience with Microsoft Visual Studio for database development and integration with application layers., • Familiarity with .NET-based web applications and integration considerations. .NET 5+, ASP.NET, HTML5, and modern front-end frameworks like React and Angular., • Experience working on government or education sector modernization projects., • Understanding of CI/CD pipelines and DevOps practices as applied to database deployment including Azure DevOps toolchains. The projected compensation range for this position is $134,400 to $165,300 per year benchmarked in the New York area. The salary range provided is a good faith estimate representative of all experience levels. Salary at LCG is determined by various factors, including but not limited to role, location, the combination of education/training, knowledge, skills, competencies, certifications, and work experience. LCG offers a competitive, comprehensive benefits package which includes health insurance options (medical, dental, vision), life and disability insurance, retirement plan contributions, as well as paid leave, federal holidays, professional development, and lifestyle benefits. Devoted to Fair and Inclusive Practices All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. If you are interested in applying for employment with LCG and need special assistance or an accommodation to apply for a posted position, contact our Human Resources department by email at . Securing Your Data Beware of fraudulent job offers using LCG's name. LCG will never request payment-related details or advancement of money during the application process. Legitimate communication will only come from lcginc.com or emails, not free commercial services like Gmail or WhatsApp. If you receive suspicious emails asking for payment or personal information, contact us immediately at . If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.

Job Description Job Title: Senior Database Administrator Onsite Requirement: A couple of days onsite required and travel to different sites. Job Summary: LCG is seeking a Senior Database Administrator (DBA) to lead the design, development, migration, and administration of modern SQL Server database systems in support of the client Applications Modernization Project. The Senior DBA will play a critical role in transitioning legacy DB2 systems to Microsoft SQL Server in a virtualized, scalable environment. This role also includes performance tuning, data modeling, backup strategy, and implementation of reporting services such as SSRS and SSAS. The candidate must also bring experience with Azure SQL (VM, PaaS, DaaS), ETL tools, database replication, and Power BI for reporting and visualization. Key Responsibilities • Lead end-to-end database architecture design, implementation, and administration for the client’s system modernization., • Perform data modeling and optimization to support OLAP and OLTP workloads using ERWIN or similar tools., • Migrate legacy DB2 databases to Microsoft SQL Server (2014/2016/2019) ensuring data integrity, security, and performance., • Configure and maintain SQL Server in clustered and virtual environments, including high availability/disaster recovery solutions., • Develop and maintain SSIS packages for data migration, transformation, and system integration with client systems., • Implement and manage SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) solutions., • Develop, optimize, and maintain stored procedures, maintenance jobs, and ETL workflows across legacy and modern systems., • Support and implement database replication strategies to improve scalability and availability., • Configure and administer Azure SQL solutions across VM, PaaS, and DaaS architectures., • Conduct performance tuning, query optimization, and monitoring of SQL databases to ensure system reliability during peak periods (e.g., summer hiring)., • Collaborate with development teams to integrate data solutions and ensure smooth backend operations., • Ensure cross-browser and cross-platform compatibility from a data layer perspective., • Define and enforce database security protocols and participate in system security audits., • Support functional and performance testing by managing realistic data sets and test environments., • Provide documentation, best practices, and training to development and support teams., • Coordinate with middleware integration services such as IBM Integration Bus (IIB), IBM API Connect, and IBM Security Access Manager (ISAM/OpenID/OAuth 2.0)., • Experience: Minimum 8+ years of hands-on database administration and development experience., • Technical Proficiency:, • SQL Server (2014/2016/2019), • SSIS, SSRS, SSAS, • DB2 (legacy system knowledge for migration purposes), • OLAP and OLTP modeling using ERWIN or similar tools, • Windows Server environments and virtualization platforms, • Azure SQL (VM, PaaS, DaaS), • Stored procedures, maintenance jobs, ETL tools, • Performance tuning, backup/restore, replication, and database maintenance, • Experience with Power BI for dashboarding and reporting is a plus., • Experience integrating with Redis and other caching technologies is preferred., • Proven experience designing and implementing database solutions in clustered and virtual environments., • Familiarity with modern programming languages including .NET 5+, ASP.NET, HTML5, and front-end frameworks such as React or Angular., • Experience using Azure DevOps for version control, CI/CD, and deployment management., • Expertise in SQL Server performance tuning, indexing, query optimization, and backup/restore strategies., • Strong knowledge of system integration, workflow automation, and bulk email handling in high-volume environments., • Experience supporting large-scale modernization projects for public sector clients (preferred). The projected compensation range for this position is $133,800 to $161,200 per year benchmarked in the New York area. The salary range provided is a good faith estimate representative of all experience levels. Salary at LCG is determined by various factors, including but not limited to role, location, the combination of education/training, knowledge, skills, competencies, certifications, and work experience. LCG offers a competitive, comprehensive benefits package which includes health insurance options (medical, dental, vision), life and disability insurance, retirement plan contributions, as well as paid leave, federal holidays, professional development, and lifestyle benefits. Devoted to Fair and Inclusive Practices All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. If you are interested in applying for employment with LCG and need special assistance or an accommodation to apply for a posted position, contact our Human Resources department by email at . Securing Your Data Beware of fraudulent job offers using LCG's name. LCG will never request payment-related details or advancement of money during the application process. Legitimate communication will only come from lcginc.com or emails, not free commercial services like Gmail or WhatsApp. If you receive suspicious emails asking for payment or personal information, contact us immediately at . If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.

Job Description Job Title:Senior Financial Data Analyst Location:New York, NY 10019 Salary/Payrate:$115K-$130K annually plus a performance-based bonus and AWESOME benefits!!! Work Environment:Hybrid (1# of days WFH) Term:Permanent / Fulltime Bachelors degree required:Yes Referral Fee: AMS will pay $500 should the person you refer gets hired JOB DESCRIPTION #LI-SS1 Our client, an AMLaw 50 firm, is looking to hire a Senior Financial Data Analyst at their offices in New York City. This is a full time, direct hire role paying an annual salary of $115K to $130K plus a performance-based bonus and excellent benefits package. The role requires a Bachelors degree and will allow for remote work one day a week. Overview: Senior Financial Data Analyst is a key player in our clients financial data ecosystem, developing, designing and project managing dashboards and reporting that support the firm. The role demands an elevated level of technical expertise specifically in Power BI, financial knowledge, and the ability to communicate effectively with stakeholders across the firm. Key Responsibilities: • Design, develop and maintain insightful and visually compelling Power BI dashboards and reports for various end user groups., • Collaborate with cross-functional teams and stakeholders to understand requirements and design data model for accurate and efficient reporting., • Lead analytical projects, manage timelines and ensure timely delivery of high-quality dashboards and reports., • Maintaining data accuracy and integrity within BI systems., • Mentor and support junior analysts, sharing expertise in Power BI and data analysis best practices., • Troubleshoot complex data issues and identify root causes, collaborating with technology teams to resolve performance. Requirements • Advanced Power BI developer, • Advanced SSRS developer, • Expertise in SQL and DAX, • Strong analytical and problem-solving skills., • Excellent communication skills, • Strong critical thinking and problem-solving capabilities, • Ability to translate business needs into technical specs

Job Description Job Type: W2 Contract Role, Full Time, On Site. Role is tied to a multi-year project contract. Industry: Information Technology / Data Engineering About Us At Red Hill Consulting LLC, we are more than just consultants—we are problem solvers, innovators, and strategic partners. With expertise in IT, governance, risk management, compliance, and business transformation, we help organizations navigate complexity and drive meaningful change. Our team specializes in delivering tailored, high-impact solutions that empower businesses to optimize processes, enhance security, and leverage data-driven insights. Whether it's implementing cutting-edge technology, refining operational strategies, or ensuring regulatory compliance, we take a proactive, hands-on approach to solving challenges. Rooted in our core values of Integrity, Innovation, and Excellence, we foster a collaborative environment where expertise meets execution. Our clients span industries such as finance, healthcare, government, and technology, and we pride ourselves on delivering measurable results that drive sustainable success. About the Role We are seeking an experienced Data Warehouse Architect to lead the design, development, and optimization of large-scale enterprise data platforms for a key client. This is a multi-year consulting engagement focused on building robust data warehouse and analytics solutions that drive data-driven decision-making across the organization. In this role, you will architect end-to-end data solutions, from modeling and integration to reporting and analytics, while ensuring best practices in governance, security, and scalability. You will collaborate with technical managers, engineers, and business stakeholders to deliver high-impact data initiatives and create a modern, reliable, and efficient data ecosystem. This position is ideal for a senior-level architect with deep expertise in data warehousing, cloud-based data solutions, and advanced analytics tools, who thrives in a fast-paced, project-driven environment. Key Responsibilities • Architect Enterprise Data Platforms: Design and implement scalable, high-performing data warehouse and analytics solutions in both on-premises and cloud environments., • End-to-End Data Engineering: Oversee the entire data lifecycle, including modeling, integration, ETL/ELT processes, data cleansing, and transformation., • Data Platform Development: Build, optimize, and maintain complex data warehouse models and pipelines using SQL Server, Azure Data Factory, and other Azure services., • Analytics Enablement: Support BI and reporting frameworks, integrating with tools such as Power BI, Cognos, and Tableau for enterprise reporting., • Performance Optimization: Write and tune complex T-SQL queries, stored procedures, and scripts to improve system efficiency and reliability., • Governance & Security: Implement data governance practices, manage data quality, and establish robust security protocols across platforms., • Environment Management: Maintain and upgrade production and non-production environments, ensuring uptime, stability, and compliance., • Troubleshooting & Support: Resolve escalated technical issues, conduct root cause analysis, and ensure data integrity across systems., • Collaboration & Leadership: Partner with engineering teams, provide technical guidance, and mentor junior engineers. Education & Experience: • Bachelor’s degree in Computer Science, Engineering, Information Systems, or a related field., • 12+ years of experience in architecting, designing, and developing data warehouse and database solutions in both on-premises and cloud environments., • Proven track record in end-to-end data warehouse development, including ETL/ELT, data modeling, integration, and optimization., • Hands-on experience with SQL Server technologies (SSIS, SSAS, SSRS), advanced T-SQL, and complex query performance tuning., • Strong expertise in Azure Data Platform services (Azure SQL Database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS)., • Experience supporting BI frameworks like Power BI, Cognos, or Tableau., • Deep understanding of data governance, data management, and data security practices., • Skilled in designing scalable data models and analytics systems that meet enterprise standards., • Knowledge of data warehouse best practices, schema design (star/snowflake), and performance optimization., • Strong scripting skills for automation and database management tasks., • Cloud migration and hybrid environment experience is highly desirable., • Exceptional communication and presentation skills, with the ability to engage technical and non-technical stakeholders., • Strong leadership, mentorship, and collaboration skills in cross-functional teams., • Analytical mindset with problem-solving expertise and attention to detail., • Be part of a dynamic, mission-driven team that values innovation and strategic thinking., • Work on diverse, high-impact projects across multiple industries., • Opportunities for professional development and career growth., • Competitive salary and benefits package.

Job DescriptionBenefits: • 401(k), • Competitive salary, • Opportunity for advancement, • Training & development Job Type: W2 Contract Role, Full Time, On Site. Role is tied to a multi-year project contract. Industry: Information Technology About Us At Red Hill Consulting LLC, we are more than just consultantswe are problem solvers, innovators, and strategic partners. With expertise in IT, governance, risk management, compliance, and business transformation, we help organizations navigate complexity and drive meaningful change. Our team specializes in delivering tailored, high-impact solutions that empower businesses to optimize processes, enhance security, and leverage data-driven insights. Whether it's implementing cutting-edge technology, refining operational strategies, or ensuring regulatory compliance, we take a proactive, hands-on approach to solving challenges. Rooted in our core values of Integrity, Innovation, and Excellence, we foster a collaborative environment where expertise meets execution. Our clients span industries such as finance, healthcare, government, and technology, and we pride ourselves on delivering measurable results that drive sustainable success. About the Role We are seeking a detail-oriented ETL Developer to join a leading clients enterprise data and analytics team. In this role, you will be responsible for designing, developing, and maintaining data integration solutions that ensure high-quality, reliable data for analytics and reporting. This is a multi-year consulting engagement focused on building and optimizing enterprise data warehouses, ETL pipelines, and reporting environments. You will collaborate closely with business analysts, database administrators, and reporting teams to deliver efficient and scalable data solutions that drive informed decision-making. This position is ideal for a highly technical professional with deep SQL expertise, strong ETL development skills, and a passion for creating streamlined data workflows in a large, complex environment. Key Responsibilities • ETL Design & Development: Build and maintain robust ETL pipelines using SQL Server Integration Services (SSIS) and related technologies to support enterprise data warehouse operations., • Data Warehouse Management: Contribute to the design and optimization of data warehouse structures, ensuring scalability and data integrity., • Performance Optimization: Collaborate with DBA and reporting teams to tune queries, optimize ETL jobs, and improve data processing efficiency., • Cloud Data Integration: Support data platform initiatives using Azure SQL Database, Azure Data Factory, Azure Storage, and Azure Pipelines., • Monitoring & Troubleshooting: Monitor ETL workflows, proactively resolve job failures, and maintain reliable data delivery., • Data Quality Assurance: Implement data validation, cleansing, and transformation processes to ensure accuracy and consistency., • Collaboration: Work closely with cross-functional teams to translate business requirements into technical solutions., • Reporting Support: Provide integration support for BI environments such as Cognos, Power BI, or Tableau., • Documentation: Develop detailed documentation for ETL processes, workflows, and troubleshooting guidelines., • Continuous Improvement: Recommend and implement improvements to ETL architecture and processes for scalability and automation. Qualifications & Skills Education & Experience: • Bachelors degree in Computer Science, Engineering, or a related field., • 8+ years of experience designing, developing, testing, and supporting ETL processes and enterprise data warehouses., • Proven experience with SQL Server technologies (SSIS, SSAS, SSRS) for integration, reporting, and analytics., • Strong expertise in T-SQL development, including writing complex queries, stored procedures, and views., • Experience with Azure Data Services (Azure SQL Database, Azure Data Factory, Azure Storage, Azure Pipelines, Azure IaaS/PaaS)., • Skilled in ETL workflow orchestration, optimization, and error-handling strategies., • Strong understanding of data warehouse concepts, schema design, and relational database principles., • Experience maintaining and monitoring ETL job schedules to ensure timely data delivery., • Hands-on experience with query performance tuning and database optimization., • Excellent communication and collaboration skills to work with developers, reporting teams, and business stakeholders., • Strong analytical and problem-solving abilities with a focus on accuracy and efficiency., • Ability to work independently, prioritize tasks, and meet deadlines in a fast-paced environment., • Be part of a dynamic, mission-driven team that values innovation and strategic thinking., • Work on diverse, high-impact projects across multiple industries., • Opportunities for professional development and career growth., • Competitive salary and benefits package.

Net developer / Programmer Analyst. NET - in-depth knowledge and experience in converting programs from MS Visual Basic to. Net, Power BI, SSRS, Crystal reports.

Computer Science or Information Technology with at least 5+ years of experience in BI Technologies. Extensive experience with SQL, SQL Server Reporting Services (SSRS), Power BI Services, MDX and DAX functions. Perform detailed analysis of source systems and source system data and model that data in

Company Description Job Description The New York City Department of Youth and Community Development (DYCD) invests in a network of community-based organizations and programs to alleviate the effects of poverty and to provide opportunities for New Yorkers and communities to flourish. Permanent Computer Specialist (Software) or on the Computer Specialist (Software) Civil Service List** The New York City Department of Youth and Community Development (DYCD) invests in a network of community-based organizations and programs to alleviate the effects of poverty and to provide opportunities for New Yorkers and communities to flourish. The SSIS / SSRS / Power BI developer will report to the Deputy Director of the Data Portfolio and will be responsible for working with the team to develop and support the data needs of the agency. The candidate will be responsible for: • Work within the underlying architecture for all software related projects assigned. -Write clean SQL queries, functions, and stored procedures. Optimize and improve existing code. COMPUTER SPECIALIST (SOFTWARE) - 13632 Qualifications (1) A baccalaureate degree from an accredited college, including or supplemented by twenty-four (24) semester credits in computer science or a related computer field and two (2) years of satisfactory full-time software experience in designing, programming, debugging, maintaining, implementing, and enhancing computer software applications, systems programming, systems analysis and design, data communication software, or database design and programming, including one year in a project leader capacity or as a major contributor on a complex project; or (2) A four-year high school diploma or its educational equivalent and six (6) years of full-time satisfactory software experience as described in "1" above, including one year in a project leader capacity or as a major contributor on a complex project; or (3) A satisfactory combination of education and experience that is equivalent to (1) or (2) above. College education may be substituted for up to two years of the required experience in (2) above on the basis that sixty (60) semester credits from an accredited college is equated to one year of experience. A masters degree in computer science or a related computer field may be substituted for one year of the required experience in (1) or (2) above. However, all candidates must have a four year high school diploma or its educational equivalent, plus at least one (1) year of satisfactory full-time software experience in a project leader capacity or as a major contributor on a complex project. NOTE: In order to have your experience accepted as Project Leader or Major Contributor experience, you must explain in detail how your experience qualifies you as a project leader or as a major contributor. Experience in computer operations, technical support, quality assurance (QA), hardware installation, help desk, or as an end user will not be accepted for meeting the minimum qualification requirements. Special Note To be eligible for placement in Assignment Level IV, in addition to the Qualification Requirements stated above, individuals must have one year of satisfactory experience in a project leader capacity or as a major contributor on a complex project in data administration, database management systems, operating systems, data communications systems, capacity planning, and/or on-line applications programming. Additional Information The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.

Job Title: Senior Payment Engineer Company: Smartshore Services LLC Location: New York, NY (Hybrid: 2-3 days in office per week) About Us: Smartshore Services LLC is a 14-year-old IT services and procurement consulting company dedicated to delivering process transformations for financial services clients. With expertise in detailed process mapping, Robotic Process Automation (RPA), Machine Learning (ML), and Artificial Intelligence (AI), we help our clients adopt advanced technology tools, such as reverse auctions and global workforce management systems. Operating in both the USA and India, Smartshore is proud to count several global banks among our clients. Job Description: Smartshore Services LLC is seeking a Senior Payment Engineer with expertise in Local and Foreign Currency Payment Platforms, APIs, and middleware systems. This hybrid role is ideal for a seasoned professional with 10-12 years of experience in payment systems design, implementation, and support, including exposure to SWIFT, UAEFTS, ISO 20022, and related platforms. The position offers a dynamic, fast-paced environment with opportunities to work on cutting-edge technology solutions. Key Responsibilities: Change Management - Implement new projects in Local/Foreign Currency Payment Platforms, Reporting, Automation, Middleware, and API Connect areas. - Propose, design, and document solutions for critical payment environments. - Carry out change management activities, including process definitions and implementations. - Provide solution guidance and process enhancements for various environments and systems. - Manage vendors and execute projects for specialized areas, including middleware and API Gateways. - Analyze business requirements and translate them into technical specifications. - Review and validate High-Level Design (HLD) and technical documentation. - Troubleshoot complex design issues and recommend solutions. - Lead system integration and ensure seamless delivery of projects within defined SLAs. Support and Maintenance - Provide 24/7 support on a rotational basis. - Perform root cause analysis (RCA) for incidents and deploy tested fixes in production environments. - Conduct proactive application maintenance to reduce incidents and ensure system stability. - Ensure application availability, adherence to patching cycles, and proper alerting mechanisms. - Maintain compliance with organizational policies, including audit, ISG, and lean frameworks. Operating Environment and Collaboration - Coordinate with functional teams and vendors to achieve project goals. - Provide administrative support, including status reporting, timesheets, and documentation. - Conduct knowledge sharing and team training activities. Problem Solving and Decision-Making - Analyze and address system defects, user issues, and process challenges. - Recommend and implement effective solutions to obstacles in systems or processes. - Use sound judgment to prioritize tasks and achieve results within deadlines. Essential Skills & Qualifications: - 10-12 years of experience in payment system design, implementation, and support. - Proficiency with UAEFTS, SWIFT, API, and middleware platforms (e.g., MQ, API Gateways). - Strong knowledge of SQL Server (SSIS, SSRS), .NET, and payment systems like FED, CHIPS, SWIFT Alliance/Gateway. - Hands-on experience with emerging payment systems, ISO 20022, SWIFT GPI, and instant payments. - Ability to design, implement, and document scalable solutions. - Strong banking domain knowledge and vendor management experience. - Excellent problem-solving, analytical, and communication skills. - Ability to work on multiple projects with tight deadlines in a dynamic environment. - Bachelor's or Master's degree in Computer Science, Engineering, or a related field. Environment: Windows 7/10, Windows Server, SQL Server (2008 R2, 2012, 2014), Oracle, SWIFT, UAEFTS, IIS Web Server, IBM WebSphere, Microsoft Office Suite, and other enterprise tools. Why Join Us? - Hybrid work environment offering flexibility and collaboration. - Work on large-scale payment projects with cutting-edge technologies. - Competitive compensation and benefits package. - Opportunities to grow and innovate in the financial services industry. How to Apply: If you're ready to excel in a challenging and rewarding role as a Senior Payment Engineer, submit your resume and a brief cover letter highlighting your experience to jyoti.p@smartshore.us. Join Smartshore Services LLC and help global organizations transform their payment systems and embrace modern technology solutions! Skills: Egifts,payments,Swift

Job Description Remote with 2 days a week in NYC The Application Developer is a key member of the Enterprise Platforms group within the Information Technology department and will serve in a variety of roles under the direction of the Senior Manager of Application Development. We are seeking a highly skilled and experienced Software Developer with expertise in .Net, Web APIs, C#, SQL Server, and Angular to join our dynamic team. The ideal candidate will play a key role in designing, developing, and maintaining innovative software solutions that meet business needs. This role requires a strong foundation in application architecture, problem-solving, and team collaboration. Responsibilities • Design, develop, test, and maintain robust and scalable software applications using .Net (C#), SQL Server, and Angular., • Collaborate with stakeholders to gather and understand business and technical requirements., • Design, optimize, and maintain complex databases using SQL Server, ensuring data integrity and performance., • Build user-friendly and responsive front-end interfaces using Angular., • Write clean, maintainable, and efficient code following best practices, design patterns, and coding standards., • Work on integrating APIs, web services, and third-party libraries with in-house applications., • Identify and resolve performance bottlenecks in the application and database layers., • Mentor junior developers, provide technical guidance, and actively participate in code reviews., • Develop unit tests, perform debugging, and ensure the delivery of high-quality software., • Proficient in .Net technologies, especially C#, Web API, .Net Core., • Strong experience with Angular (preferably Angular 8+)., • Expertise in SQL Server, including stored procedures, triggers, indexing, and query optimization., • Experience with RESTful APIs, Web APIs, and MVC frameworks., • Knowledge of software design patterns and principles (e.g., SOLID, DRY)., • Familiarity with version control systems (e.g., TFS, Git)., • Strong problem-solving skills and attention to detail., • Ability to work both independently and in a team environment., • Excellent verbal and written communication skills., • 4-year degree preferred., • Experience with Agile or Scrum development methodologies., • Knowledge of cloud platforms such as Azure or AWS., • Familiarity with DevOps tools and practices (CI/CD pipelines, TeamCity)., • Experience with reporting tools or frameworks such as SSRS or Tableau.

Innova Solutions has a client that is immediately hiring for a Senior Oracle PL/SQL Developer/Architect (w/ ETL Informatica/DW Exp.Jersey City, NJ Position Type: W2-Hybrid Contract – (***Hybrid - 3 Days Onsite and 2 Days Remote work in a week!!!) Location: Jersey City, NJ 07302 Duration: 12-18 Mon

We are supporting a large healthcare organization that is currently seeking a Data Analyst to join their team.This role offers the opportunity to work on meaningful projects that directly support healthcare operations and decision-making.Location: Midtown Manhattan, NY Schedule: Monday–Friday, 9:0

Job Title: Data Analyst / Project Coordinator Location: Jersey City, NJ, Hybrid (3 days in-office, 2 days remote) Pay Rate: Up to $55.Duration: Up to 1 year (possible extension) About the Role We are seeking a highly organized, proactive, and resourceful professional to support the Wealth Management

THIS ROLE WILL BE 100% REMOTE FOR SOMEONE LIVING IN THE EASTERN OR CENTRAL US TIME ZONE.NO H1S OR 3 RD PARTIES New role for a Software developer to work with clients on upgrades, modifications and integrations of systems, primarily trading, data feed and financial systems.This person will be working

As a software developer, you’ll be the brain behind crafting, developing, testing, going live and maintaining the system.You are passionate in understanding the business context for features built to drive better customer experience and adoption.We value engineers who love data and appreciate the

NYC Department of Finance (DOF) is responsible for administering the tax revenue laws of the city fairly, efficiently, and transparently to instill public confidence and encourage compliance while providing exceptional customer service.The Finance Information Technology (FIT) Division designs, build

We are looking for an enthusiastic junior software developer to join our experienced software design & development team.To ensure success as a junior software developer, you should have a good working knowledge of basic programming languages, the ability to learn new technology quickly, and the abil

Founded in 1998 United Legwear & Apparel Co.ULAC) is a global designer, manufacturer and distributor of socks, legwear, sportswear, bodywear, and accessories.As one of the leading resources in the industry, ULAC offers a full range of apparel, from newborn/toddler sizes through teens and adults, tha

Marex is a global financial services platform, providing essential liquidity, market access and infrastructure services to clients in the energy, commodities and financial markets.The Group provides comprehensive breadth and depth of coverage across four core services: Market Making, Clearing, Hedgi

Join Our Team to Build Cutting-Edge AI Solutions!.We’re looking for a driven, talented Software Engineer to develop innovative AI-driven tools that push the boundaries of what’s possible.If you’re passionate about coding, eager to work on Large Language Models (LLMs), and excited to tackle com

Develop high quality, robust code.Oversee the platform, day to day requests, long term projects, and strategy of the team.Continually enhance the team's performance by eliminating Toil through automation.Eliminate waste in the SDLC process.Ensure platform is fully compliant to compliance, security a

NYC Department of Finance (DOF) is responsible for administering the tax revenue laws of the city fairly, efficiently, and transparently to instill public confidence and encourage compliance while providing exceptional customer service.The Finance Information Technology (FIT) Division designs, build

Join us in building the future of finance.Our mission is to democratize finance for all.An estimated $124 trillion of assets will be inherited by younger generations in the next two decades.The largest transfer of wealth in human history.If you’re ready to be at the epicenter of this historic cult

Cubist Systematic Strategies, an affiliate of Point72, deploys systematic, computer-driven trading strategies across multiple liquid asset classes, including equities, futures and foreign exchange.The core of our effort is rigorous research into a wide range of market anomalies, fueled by our unpara

MetaSquare Inc is looking for a passionate Software Engineer to design, develop and install software, and web technology solutions.The successful candidate will be able to build high-quality, innovative and fully performing software in compliance with coding standards and technical design.Design, mo

At Lanter, we are on a mission to revolutionize the way businesses leverage technology to enhance their operations and customer experiences.We are currently seeking a passionate and motivated Software Developer to join our dynamic team.In this role, you will have the opportunity to work on innovativ

Zenly is a real estate tech startup, where you can watch video tours of apartments and rent online without a broker.We are providing transparency and making the apartment renting experience more Zen! For more information, see.We're looking for an ambitious student to join as a summer intern (with th

Customer Service Center, Underwriting, and Sales teams by providing actionable insights through data analysis and comprehensive reporting.This role requires expertise in Tableau for creating reports and dashboards, proficiency in SQL Server for data extraction and query management, and the ability t

Oracle database development life cycle, including data modeling, architecture design, SQL/PLSQL development, unit testing, and production support.Good exposure of new Oracle version's inbuilt functions and features.Create, enhance, and maintain reusable database objects.Perform SQL query optimizatio

Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining the integrity and performance of company databases Must guarantee that data is stored securely and optima

Oracle database development life cycle, including data modeling, architecture design, SQL/PLSQL development, unit testing, and production support.Good exposure of new Oracle version’s inbuilt functions and features.Create, enhance, and maintain reusable database objects.Perform SQL query optimizat

Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining the integrity and performance of company databases Must guarantee that data is stored securely and optima

Join Mitsubishi UFJ Financial Group.Do you want your voice heard and your actions to count? Discover your opportunity with Mitsubishi UFJ Financial Group (MUFG), one of the world's leading financial groups.Across the globe, we're 120,000 colleagues, striving to make a difference for every client, or

Responsibility for the evaluation of database software purchases Supervision of modifications to any existing database software to meet the needs of their employer Responsibility for maintaining the integrity and performance of company databases Must guarantee that data is stored securely and optima

Roles & Responsibilities: Analyze financial data, including sales revenue, claims, and incentives to identify trends, patterns, and insights.

Assignment details: Prefer local candidate to NYC with ability to be onsite as-needed (pre-scheduled), but open to remote resource with expectation to join meetings on camera and work.

Seasoned LoanIq Data Migration Project Manager.BizTek People is looking for a seasoned LoanIq Data Migration Project Manager for our client in NYC and NJ!.Seeking a seasoned Project Manager to support a lending platform replacement initiative.The role involves leading the implementation of a new loa

Bring your energy to the role of Netflix Data Analyst to adapt to shifting priorities and business needs, work collaboratively across teams and departments, and provide excellent service to customers and team members.Other duties include gain knowledge of company offerings to better serve clients, f